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.

rkottap's avatar
rkottap
Frequent Visitor
2 years ago

Hi,
Try below.

Columns from Different Tables (IF) =
VAR SelectedStoreName = SELECTEDVALUE ( Store[Name] )
VAR SelectedStoreID = SELECTEDVALUE ( Customer[StoreID] )

RETURN
IF (SelectedStoreName = "A Bike Store" && SelectedStoreID = 934, "Working", "Not Working")

  • Prarabdha_07's avatar
    Prarabdha_07
    Frequent Visitor
    2 years ago

    Same thing , values are duplicating