Forum Discussion
Solved
Clarification Needed: How Filters Work
As someone who is new to Power BI and just starting to learn, I'm trying to rank products based on their orders. However, I'm encountering an issue where the ranking does not update correctly when I ...
Initially, the DAX expression wasn't working because I created a calculated column instead of a measure. Once I used the same formula as a measure, it worked perfectly.
RankProducts = RANKX(ALLSELECTED('Product Lookup'), [Total Orders], ,DESC,Dense)
Initially, the DAX expression wasn't working because I created a calculated column instead of a measure. Once I used the same formula as a measure, it worked perfectly.
RankProducts = RANKX(ALLSELECTED('Product Lookup'),
[Total Orders],
,DESC,Dense)