Forum Discussion

wbart's avatar
wbart
Helper I
5 years ago
Solved

TOP N without building sum

Hello,

I like to build a TOP N ranking. If I do so power Bi build automaticly the sum of the values which have mor then one items. I do not want this. Can I switch this off?

 

Best regards

wbart

Need Help

3 Replies

  • nvprasad's avatar
    nvprasad
    Solution Sage
    5 years ago

    Hi,

    You can create a custom measure considering only products which you want to consider then use that measure in the TOPN value section.

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

    • wbart's avatar
      wbart
      Helper I
      5 years ago

      Hello nvprasad,

      That's the point. I do want to use all the data and I will not rename the subjects to make them unique.