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 all,
I have a simple table which currently is set to show me the TOP 10 markets according to annual sales.
However, I would like to force the inclusion of a specific market (example: Russia) that does never appear on that TOP 10, regardless of the year.
Is there anyway that I can always show the TOP according to a value and ALWAYS force the inclusion of this specific market?
Thank you!
Hi @aicms
Create measures to exclude the specific market.
annual value =
CALCULATE (
SUM ( 'Table'[sales] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[market] <> "a"
&& 'Table'[year]
= MAX ( 'Table'[year] )
&& 'Table'[market]
= MAX ( 'Table'[market] )
)
)
rank = IF([annual value]<>BLANK(),RANKX(ALL('Table'[market]),[annual value],,DESC,Dense))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-juanli-msft,
Thank you very much for your kind help! I did not try your solution because it is designed to "exclude" a specific market and I really wanted to "force"/include always.
Hi @aicms
Have a look at my example, do you want to include one specific market or exclude?
You can provide an example and give your desired result based on my example.
Best Regards
Maggie
@aicms , Try a measure like
CALCULATE([sales], filter(Table,[Rank]<=10 && Table[Country] = "Russia"))
Hi @amitchandak ,
Thank you for your help!
It's not working but it must be something that I'm doing wrong (I am kinda new at this). I am using the following formula (excluding Russia for now):
= CALCULATE([Euros_Sales]; filter(Geography; [Euros_Rank {Geography}] <= 10))
where
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |