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 there
I have a card for a country's ranking last year, and I want to ensure that the 'All' value that displays before any filtering is applied, is the value of the 'global' ranking. At the moment, the card is summing all individual countries giving a total of 293 as the ranking for all, which is fair enough for PowerBI's logic, however I need global to display for all which in fact is 7. Is this possible?
Attached below is screengrab of current situation.
Thanks
Thanks @amitchandak , however I do not want to disable the interactions as I need the card to change and display a value when a country is selected from the 'market' slicer. Essentially, in the table for rank columnn there is a row where country is equal to 'Global' and the rank value is 7. This is the first row in the column, is there a measure I can use to pick up this value and display it, before the slicer is used and then a country's value displays? There is only one row per country.
@AJM95 , You can disable interaction between card and slicer
How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4
or try measure like
Global Ranking =
CALCULATE(
MIN('Table'[CountryRank]),
ALL(Table)
)
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 |
---|---|
99 | |
98 | |
76 | |
66 | |
59 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |