cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Compare price

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.

2018-11-23_10-09-06.jpg
Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Compare price

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-yulgu-msft Super Contributor
Super Contributor

Re: Compare price

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])))

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Super User
Super User

Re: Compare price

I wrote something like this once:

 

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Anonymous
Not applicable

Re: Compare price

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

2018-11-23_10-09-06.jpg

Super User
Super User

Re: Compare price

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.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Anonymous
Not applicable

Re: Compare price

But country is coming form the same table.

Super User
Super User

Re: Compare price

Create a new table:

 

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-yulgu-msft Super Contributor
Super Contributor

Re: Compare price

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])))

1.PNG

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 303 members 3,332 guests
Please welcome our newest community members: