Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dax for competitor data

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
SKU89675
Competitor89675

 

But I want it to reflect different numbers.

3 Replies

  • Mkarwa-123's avatar
    Mkarwa-123
    Icon for Resolver II rankResolver II
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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

      • Mkarwa-123's avatar
        Mkarwa-123
        Icon for Resolver II rankResolver II
        3 years ago

        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.