Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
)
)
Solved! Go to Solution.
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 @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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
53 | |
46 | |
15 | |
12 |