Forum Discussion
Grouping based on Topn - Not adding together
Hi PowerBi Friends,
I have a table and grouped it based on TopN. However, the same entity (company name) is splitting into other TopN where it shouldn't be. e.g Company XYZ was on Top10 and also showing in the Top50 as well. It should be summed together and only be placed on 1 particular TopN. How can I do this? Attached is my measure.
Total Invoice By Rank Group =
CALCULATE(
[Total Invoice],
FILTER(
FactFinalisedInvoicesDetailed,
COUNTROWS(
FILTER(
'Customer Rank',
[Rank by Group Owner and Invoice Type] >= 'Customer Rank'[Min Rank]
&& [Rank by Group Owner and Invoice Type] <= 'Customer Rank'[Max Rank]
)
) > 0
)
)
Hi rbalza
It's kind of obvious that if something is in TOP10, it'll be in TOP50 as well when you use the same ranking measure. This is what one would even expect and one would be very perplexed if that was not the case (a mistake coming to mind immediately). Also, there's no clear meaning to this sentence: "It should be summed together and only be placed on 1 particular TopN." In which "particular TOPN"?
2 Replies
Hi rbalza
It's kind of obvious that if something is in TOP10, it'll be in TOP50 as well when you use the same ranking measure. This is what one would even expect and one would be very perplexed if that was not the case (a mistake coming to mind immediately). Also, there's no clear meaning to this sentence: "It should be summed together and only be placed on 1 particular TopN." In which "particular TOPN"?
Hi daxer-almighty , I wanted to group this based on the TopN given. Apologies for the confusing sentences.
