Forum Discussion

pollyog's avatar
pollyog
Icon for Advocate I rankAdvocate 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
Icon for Microsoft Employee rankMicrosoft 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

pollyog's avatar
pollyog
Icon for Advocate I rankAdvocate I
8 years ago

Thank you very much! It worked like a charm!