Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Trying to compare 2 skus from the same column

Hi There   I'm trying to compare one product with another through a price index (basically the price of Product A against product B)   However, In order to do this, It's currently fixed meaning i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

I think you can create a DimManufacturer table with all manufacturer in it and use selectedvalue() function.

 

12 Months Our manufacturer Price Per Unit =
CALCULATE (
    [12 Months Price Per Unit],
    'X Database V3'[Level 2 - Manufacturer]
        = SELECTEDVALUE ( 'DimManufacturer'[Manufacturer] )
)

If this reply still couldn't help you solve your issue, please share a sample file with me. And show me a screenshot with me.

 

 

Best Regards,
Rico Zhou

 

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

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi again,

 

I've got the 2 tables created but prices can't be selected despite being in the seperate tables. They are both connected to where the dataset is. I can only see the numbers if the same brands are selected