Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Displaying top 10 variable cost

Hi, I am trying to display a table that shows the top 10 variable cost. The data source that i have is in this format: Date Employee Basic Allowance Commission Total Employment Cost 1/...

amitchandak
6 years ago
Anonymous , first you need to unpivot the table

https://radacad.com/pivot-and-unpivot-with-power-bi
https://youtu.be/2HjkBtxSM0g

Then You need to create Rank or TOP 10

For Rank Refer these links

https://databear.com/power-bi-dax-topn-function/
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

Icon for Super User rank

Super User

6 years ago

Anonymous , first you need to unpivot the table

https://radacad.com/pivot-and-unpivot-with-power-bi
https://youtu.be/2HjkBtxSM0g

Then You need to create Rank or TOP 10

For Rank Refer these links

https://databear.com/power-bi-dax-topn-function/
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

Related content