Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rank by common value per category

Hello all! I'm trying to create a specific type of ranking. Let's assume we have the below data. Business Area Report ID Dimension Supply Chain R01 D01 Supply Chain R01 D02 Sup...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    All measures are in the attached pbix file.

    I hope this helps to get some ideas to apply to your data model.

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

I hope this helps to get some ideas to apply to your data model.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That is exactly what I was looking for! Thank you so much 🙂