Forum Discussion
Solved
FILTER Parameter in DAX
Hi I'm following an online coirse where the instructor made this DAX code and it worked fine for him, but I am getting no results. He was running an older version of PBI Desktop (June I think), this ...
Try at Category level
Sumx(filter(Values('Product Lookup'[Category]), [Avg Retail Price] > [Overall Retail Price]), [Total Orders])
Or Product level
Sumx('Product Lookup', if( [Avg Retail Price] > [Overall Retail Price], [Total Orders], blank()))
amitchandak
Super User
Super UserTry at Category level
Sumx(filter(Values('Product Lookup'[Category]), [Avg Retail Price] > [Overall Retail Price]), [Total Orders])
Or Product level
Sumx('Product Lookup', if( [Avg Retail Price] > [Overall Retail Price], [Total Orders], blank()))