CODEWITHSUNDEEP
powerbidaxpowerbi-desktopdaxstudio
Arif
Arif

Reputation: 417

Power BI DAX: How to calculate measure based the current value of dimension

I working with a Power BI report that has some measures in a fact table. We have Sales[YTD Amount] and Sales[QTR amount] in the fact table. We have another dimension named Product which has an attribute named LineItem. I want to calculate another measure like below

Updated_Qtr_Amount = If(Product[LineItem] = "Opening Balance", Sales[YTD Amount], Sales[Qtr Amount])

However, it throws an error that cannot find Product[LineItem] even though it exists in the dimension. If I use selectedvalue(Product[LineItem]), then it does not throw any error.

Can you please tell me how to access the current row value of the LineItem so that i can calculate the above measure?

Upvotes: 0

Views: 557

Answers (1)

Arif
Arif

Reputation: 417

I have tried a few ways and using selectedvalue(Product[LineItem]) will actually work. It seems like you cannot use a field name directly from the dimension table

Upvotes: 0

Related Questions