Rank Column with All selected

Question

Hi Team,&nbsp;I Need to create dynamic Ranking based on below slicer. (FY&nbsp; Year &amp; Quarter are coming from DATE table).&nbsp;Forecast Accuracy For Rank_Measure = CALCULATE(SUM('Forecast Code'[Forecast]),'Forecast Code'[event end week]&lt;= TODAY(),ALLEXCEPT('Forecast Code','Forecast Code'[Customer],'Forecast Code'[Tag]))&nbsp;Rank Column = RANKX(ALL('Forecast Code'[Customer]),CALCULATE([Forecast Accuracy For Rank_Measure]))&nbsp;Right now With FY Year, it is working fine but when I select any quarter then rank is not changing dynamically. I have tried with All selected but didn;t ge correct result.&nbsp;Could you please help me in this?&nbsp;regards,RSD&nbsp;&nbsp;&nbsp;

amitchandak · Answer

For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finalehttps://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

v-lianl-msft · Answer

Hi RSD&nbsp;,&nbsp;Could you share the sample pbix or sample data?(Please mask any sensitive data before uploading.)&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rsd · Answer

Hi&nbsp;V-lianl-msft&nbsp;,&nbsp;Please find sample PBIX at below path:&nbsp;https://drive.google.com/drive/folders/16VvWqKY2n4h53p8TEVcD8ybev0Xhf3kC?usp=sharing&nbsp;&nbsp;Thanks in advance.&nbsp;&nbsp;

Forum Discussion

Rank Column with All selected

3 Replies

Related content

Duplicate ranking

Selected field ratio and rank-Top N as slicer

Ranking KPI card

Dynamic Ranking

Rank with conditions