Comparison with Competitors' purchase rates of materials

[Anonymous]

I have a table containing purchase of Raw materials on different dates at different Rates. I also have the three competitors' data and have put them all together in one table (please see the column "Data Type").

The objective is to analyse who is buying at what price and how does it similar, higher or less than our purchase rates. The last rate of purchase is the comparative factor which means the last rate of internal data compared with last rate of competitor's data for specific raw material.

I need the following three slicers (the 3rd one will have the further three dropdown)

1. Item Description

2. Importer Name

3. Price Comparison

i. Similar Price

ii. Higher Price

iii. Better Price

Please tell me how to include the 3rd slicer in my dashboard either through calculated column or through meaaure. The sample data is attached. I appreciate your support.

https://www.dropbox.com/sh/ko9y6lo6ocwp6om/AABuUT3RK7G6yBdPCBxmv8G5a?dl=0

Regards,

Imran

[v-jayw-msft]

Hi @Anonymous ,

Please check following steps as below and see if the result achieve your expectation:

1. Create measures(content for informational purposes only):

Similar Price = IF(MAX('Sample'[Rate])>50&&MAX('Sample'[Rate])<150,MAX('Sample'[Rate]),BLANK())
Higher Price = IF(MAX('Sample'[Rate])>=150,MAX('Sample'[Rate]),BLANK())
Better Price = IF(MAX('Sample'[Rate])<=50,MAX('Sample'[Rate]),BLANK())

 2. Create table:

3. Create measure:

Measure = 
VAR sv =
    SELECTEDVALUE ( 'Price Comparison'[Price Comparison] )
RETURN
    SWITCH (
        sv,
        "Similar Price", [Similar Price],
        "Higher Price", [Higher Price],
        "Better Price", [Better Price],
        "NA"
    )

Result would be shown as below:

BTW, Pbix as attached, hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your reply but it is not working.

let me explain the requirement here;

I need to compair our purchase prices of individual item with that of competitors. I will filter the competitor name (slicer), then will select the item (slicer) and the the third slicer must give me three options, based on last purchase rate;

1. Similar price

2. Better price

3. Higher price

I have done everything and its working but I am not able to have this third slicer and need your help.

Regards,

Imran

[Anonymous]

Could anyone help me on this, I really need to sort out the solution and your support will be much appreciated.

Regards,