topic Dax for competitor data in DAX Commands and Tips

Dax for competitor data

Anonymous — Wed, 02 Aug 2023 10:37:05 GMT

I have SKU's and its competitors in the same data base. When I create a metrix with Heirarchy I see the same value of SKU even in the competitor.

Example :-

	Volume
SKU	89675
Competitor	89675

But I want it to reflect different numbers.

Re: Dax for competitor data

Mkarwa-123 — Wed, 02 Aug 2023 14:56:57 GMT

Hi Anonymous You need a flag to separate self and competition SKUs.
I usually do that.

Re: Dax for competitor data

Anonymous — Wed, 02 Aug 2023 15:01:46 GMT

Mkarwa-123 I did the same, But I see the same value for both. Can you share me PBI samples ?

Re: Dax for competitor data

Mkarwa-123 — Wed, 02 Aug 2023 17:07:23 GMT

Anonymous in this case you need a filter which shows self/competition. If it is still same then you have issue with your calculation.
Can't share smaple, it is customer data.