Forum Discussion

pollyog's avatar
pollyog
Advocate I
8 years ago
Solved

Comparing column values with measure

Hi there!   I have two tables (without relationship between them because of some businness rules). When I filter the CustomerID on table X, I have to check in every row of the table Y if this row i...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi pollyog,

     

    Based on my test, you should be able to use the formula below to create a measure, then show it with TableY[CustomerID] on the Table visual in your scenario. :smileyhappy:

    Measure = IF(MAX(TableY[CustomerID])=MAX(TableX[CustomerID]),"Yes","No")

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi pollyog,

 

Based on my test, you should be able to use the formula below to create a measure, then show it with TableY[CustomerID] on the Table visual in your scenario. :smileyhappy:

Measure = IF(MAX(TableY[CustomerID])=MAX(TableX[CustomerID]),"Yes","No")

 

Regards

rajatparihar's avatar
rajatparihar
Frequent Visitor
8 years ago

Hi, thanks for the solution. I am having a similar problem but in my case I would like you use this measure as a filter/slicer. How can I do that? TIA