TOP N without building sum

[wbart]

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

[nvprasad]

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]

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.

[amitchandak · Accepted solution]

@wbart , No, Aggregation is must because measure is needed for TOPN