RANKING DAX

[Anonymous]

Hi

I need your help please

I need to rank this matrix acording each measure 

The matrix is from a fact table and the measures come from other tables related.

Thanks

[v-yiruan-msft]

Hi @Anonymous ,

According to your screen shot, we cannot know which field are from the actual table and which are from the measure... Are the fields with numeric data ( field %Cornpl Sell Out ~ DN Jet) measures? Please tell us which fields are measures and actual fields. Besides that, please provide the calculation logic of ranking the matrix and your desired result with samples. Thank you.

Best Regards

Rena

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Appreciate your Kudos.