Dax for competitor data

[Anonymous]

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.

[Mkarwa-123]

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

[Anonymous]

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

[Mkarwa-123]

@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.