Forum Discussion
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...
Hi awsiya ,
How about this:
Here the DAX Measure:
Measure =
CALCULATE (
COUNTROWS ( 'Table' ),
OR (
'Table'[Preferred] = 'Table'[Sorted],
'Table'[Sorted] <> BLANK() && 'Table'[Preferred] = BLANK()
)
)
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Thanks Parry, I am getting the result as "5" and not '4', i guess my one is counting the Blank cells (which is row 5 as both are blank) and as such giving 5. I wanted to get the result as just "4". Is there a way to sort it please?