Comparing price of different products in the same table based on filters

[Migscruz]

Hello everyone,

I'm trying to compare the price of different products that are on the same table with the possibility of being able to choose the products that I want to compare (Example: A vs B, A vs C, A vs D, etc). I have tried in two ways that u can see in my pbi file but the filters/selector aren't working properly. In example 1, when i choose the product that i would like to compare (filter 2) the name of the products dissappear in the main table. In example 2, when i choose the product in selector 2, the measure doesn't work because it should be price of product 1 - price of product 2 and it doesn't work when i use the selector 2. I'm attaching the files here  (database and PBI File) : https://www.transferxl.com/00ZDwD8RZmtMX     . Hope u can help me.

Thanks!

[v-xulin-mstf · Accepted solution]

Hi @Migscruz,

You should also create a dimension table to store 'Product 2'.

And then create two measure as:

Product1 price = 
CALCULATE(
    MAX('Table'[ Average Price ]),
    FILTER(
        'Table',
        'Table'[Name]=ALLSELECTED('Product 1'[Name])
    )
)

Product2 price = 
CALCULATE(
    MAX('Table'[ Average Price ]),
    FILTER(
        'Table',
        'Table'[Name]=ALLSELECTED('Product 2'[Name])
    )
)

Here is the output:

Or you can try this:

Both of the output are contained in the attached demo, please try it.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!