Compare price

[Anonymous]

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

[Greg_Deckler · Accepted 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.

[v-yulgu-msft · Accepted solution]

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

[Greg_Deckler]

I wrote something like this once:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266

[Anonymous]

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

[Greg_Deckler · Accepted 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.

[Anonymous]

But country is coming form the same table.

[Greg_Deckler]

Create a new table:

New Table = VALUES('Table'[Country])