topic DAX Comparing Columns and Vs in DAX Commands and Tips

DAX Comparing Columns and Vs

Matas — Fri, 24 Jun 2022 13:42:10 GMT

Hi,

I would like to request help regards my DAX measure that I cannot figure out. I have a table with columns VALUE and CALL_Point (which contain "VA02" and "EX02" values). I need to return the count of <> BLANK() from table[VALUE] where Table[CALL_POINT] = "VA02" and is not equal <> Table[VALUE] where Table[CALL_POINT] = "EX02".
Since the CALL_POINT "EX02" and "VA02" can contain the same value, which is fine, I need the ones that differ.

This is my current DAX measure, which returns the count of Table[VALUE] for CALL_POINT = "VA02" which does not contains BLANK values.

OCR Validated Ratio =

var T1 = VALUES(Table[DOCID])

var T2 = ADDCOLUMNS(T1, "@NumOfBlanks", SUMX(FILTER(CALCULATETABLE(Table), Table[CALL_POINT] = "VA02"),

IF (Table[VALUE] <> BLANK(),1)

)

var T3 = FILTER(T2, [@NumOfBlanks] <> BLANK())

RETURN

COUNTROWS(T3)

Hopefully anyone can spend their time on helping me. Thanks in advance!

Regards,

Matas

Re: DAX Comparing Columns and Vs

Jihwan_Kim — Sat, 25 Jun 2022 12:39:30 GMT

Hi,

I am not sure if I understood your question correctly, but please try the below measure.

OCR Validated Ratio = VAR T1 = VALUES ( Table[DOCID] ) VAR T2 = ADDCOLUMNS ( T1, "@NumOfBlanks", CALCULATE ( COUNTROWS ( FILTER ( Table, Table[CALL_POINT] = "VA02" && Table[VALUE] <> BLANK () ) ) ) ) VAR T3 = FILTER ( T2, [@NumOfBlanks] <> BLANK () ) RETURN COUNTROWS ( T3 )

Re: DAX Comparing Columns and Vs

Matas — Sat, 25 Jun 2022 14:31:58 GMT

Hi Jihwan_Kim

My question was, how can I optimize the current DAX measure so that the end result would compare CALL_POINT columns "VA02" and "EX02" values, that if for column CALL_POINT "VA02" and "EX02" value is not blank and not the same from the VALUE column, return the result. I have two columns.

For example:

From this example, the function should not return anything, since the EX_02 and VA_02 values are the same, but if it would be different then I should get a corresponding result. Hopefully, this made it easier to understand the issue I am facing.

Regards,

Matas