Forum Discussion

Sanju_BI's avatar
Sanju_BI
Frequent Visitor
3 years ago

Power BI - Ranking on a Matrix Visual

Have an issue, I've encountered with the Rank Measure used for our Parent and Child categories in Power BI visualizations. We have a Rank Measure in place that effectively calculates the ranks for o...
Need Help
Show and Tell
Tips and Tricks
pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Sanju_BI  , have you created heirarchy for the parent and child columns ?
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

Sanju_BI's avatar
Sanju_BI
Frequent Visitor
3 years ago

Yes!. did so.,
Customer GP Data'[New MF Code & Parent Name] - That's my Parent field
Customer GP Data'[Customer Name & Code] - That's my child field

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi Sanju_BI ,
    Try to replace ALL with ALLSELECT in your dax function .
    Thanks,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C

    • Sanju_BI's avatar
      Sanju_BI
      Frequent Visitor
      3 years ago

      My DAX already has ALLSELECTED function, and Its giving me the Ranks as per the Parent - Child, 
      the problem lies with when drilling using + Icon.