Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DAX Help

What if we need to display Top N/Bottom N products and regions both. It should show only top 5 or bottom 5 products and regions. Only 5 row table.   Following measure works for only products.   ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi Anonymous,

    Thank you for reaching out to the Microsoft fabric community forum.  I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it.

    See there is No relationship between Products and Regions:


    Outcome:




    I am also including .pbix file for your better understanding, please have a look into it:

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

    Thank you for using Microsoft Community Forum.

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
1 year ago

Hi Anonymous,

Thank you for reaching out to the Microsoft fabric community forum. Also thanks to bhanu_gautam, for his inputs on this thread. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.

Outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Awesome solution, 

    But state name and Product name are in different table. Which has no relationship between them.

    What can we do about that?

    What needs to be changed?

    Please show us required code according to this.

     

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      1 year ago

      Hi Anonymous,

      Thank you for reaching out to the Microsoft fabric community forum.  I reproduced the scenario again, and it worked on my end. I used my sample data and successfully implemented it.

      See there is No relationship between Products and Regions:


      Outcome:




      I am also including .pbix file for your better understanding, please have a look into it:

      If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

      Thank you for using Microsoft Community Forum.