Measure to compare 2 Customers

[tqn626]

I'm trying to make a comparison view. with Customer A vs Customer B. I want to select two customer in a large list and compare how they match up together.

I know was using Selectedvalue() as an option for one customer but how would i select the other.

Best Regards,

TQN

[v-luwang-msft · Accepted solution]

Hi @tqn626 ，

See the below:

 

Detail operation refer:

Comparing Selected Categories in Power BI

And you also could use calculation groups to achieve it.

refer:https://www.youtube.com/watch?v=vlnx7QUVYME 

If question still alive ,could you pls share your sample data and expect output.

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

Best Regards

Lucien

[amitchandak]

@tqn626 , You need to have two customer slicer. And one of them should come from an independent customer table 

new table

Customer 2= [customer] //customer table

I have discussed the same for date, you can replicate that for customer

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg