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.
Hello I have a very simple table.
I need to pick a Country and then show price of all other countries. So, if I pick Australia, I need to see All other countrise and price, but do not show Austratia.
Thanks
Solved! Go to Solution.
Should be able to use the same basic concept to create a flag variable. First, don't connect your slicer to your table. Then create a flag measure like:
Measure Flag = VAR __selected = MAX('Table'[Column]) //value from slicer RETURN IF(MAX([Country]) = __selected,0,1)
Filter on this measure.
Hi @Anonymous,
Create a calculated table which lists all slicer selections. This table should be unrelated to source data table.
slicerTable = VALUES('TB1'[Country])
Add below measure to visual level filters, set its value to 0.
check = IF(SELECTEDVALUE(slicerTable[Country])=SELECTEDVALUE(TB1[Country]),1,0)
To calculate the price of selected country as a comparison, please create below measure.
value for selected country = CALCULATE(SUM(TB1[Price]),FILTER(TB1,TB1[Country]=SELECTEDVALUE(slicerTable[Country])))
Best regards,
Yuliana Gu
Hi @Anonymous,
Create a calculated table which lists all slicer selections. This table should be unrelated to source data table.
slicerTable = VALUES('TB1'[Country])
Add below measure to visual level filters, set its value to 0.
check = IF(SELECTEDVALUE(slicerTable[Country])=SELECTEDVALUE(TB1[Country]),1,0)
To calculate the price of selected country as a comparison, please create below measure.
value for selected country = CALCULATE(SUM(TB1[Price]),FILTER(TB1,TB1[Country]=SELECTEDVALUE(slicerTable[Country])))
Best regards,
Yuliana Gu
I wrote something like this once:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266
I'm not looking to aggregate data, simple want to show country and price in grid mode of all other countries then the selected country. Something like this
Should be able to use the same basic concept to create a flag variable. First, don't connect your slicer to your table. Then create a flag measure like:
Measure Flag = VAR __selected = MAX('Table'[Column]) //value from slicer RETURN IF(MAX([Country]) = __selected,0,1)
Filter on this measure.
But country is coming form the same table.
Create a new table:
New Table = VALUES('Table'[Country])
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |