Forum Discussion

awsiya's avatar
awsiya
Icon for Helper I rankHelper I
2 years ago
Solved

Both Column Values Match including a blank one

Hello all, I am encountering an issue when using DAX to perform the following calculation. I have a simple table containing only two columns, "Sorted" and "Preferred." The task at hand is to determi...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    awsiya if you don't want to add a column you can also a measure directly:

     

    Sorted Matched Preferred Measure = 
COUNTROWS ( FILTER ( Table, COALESCE ( Table[Preferred], Table[Sorted] ) = Table[Sorted] ) )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

awsiya if you don't want to add a column you can also a measure directly:

 

Sorted Matched Preferred Measure = 
COUNTROWS ( FILTER ( Table, COALESCE ( Table[Preferred], Table[Sorted] ) = Table[Sorted] ) )