Forum Discussion

Prarabdha_07's avatar
Prarabdha_07
Frequent Visitor
2 years ago
Solved

Power BI IF condition with Different table Columns

Hii, I am connecting two Tables Customer (StoreID) and Store(BusinessEntityID) --       I need to create a IF Measure using Columns from both the Tables like this -- Columns from Differen...
data protection
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Prarabdha_07 

     

    After my testing, you can put the BusinessEntityID field in place of the StoreID field in the visualization if you wish.

     

    Best Regards,
    Yulia Xu

     

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

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Prarabdha_07 

As per your measure if the condition is satisfied then working is displaying where condition is not satisfying showing Not working. 

 

Can you share the expected output by typing into excel like Input and output also?

or share the screenshot of your expected output. would be better for us to quickly solve your problem.

 

 

Prarabdha_07's avatar
Prarabdha_07
Frequent Visitor
2 years ago

this is expected --

Measure is actually duplicating the values