Comparing Two measure with each other

[Matas]

Hi guys,

Can someone help me to my issue. I have two DAX measures that returns the value from a table.

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)

and

OCR Extracted Ratio =

var T1 = VALUES(Table[DOCID])

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

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

)

)

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

RETURN COUNTROWS(T3)

I would like to output the number of rows that contain different values inside, since those measures contains ~90% of the same Values. I would like to achieve something like Return the value where OCR Extraction Value <> OCR Validation Ratio.

Regards,

Matas

[amitchandak]

@Matas , Not very clear

A measure like 

countrows(filter(Table, [Measure1]> [Measure2]))

[Matas]

Hi @amitchandak ,

I have two measures mentioned above. I need to create a measure using DAX to return the countrows that Measure1 <> Measure2. 

The Measure1 returns the countrows of CALL_Point = "EX02" and Value <> Blank.

The Measure2 returns the countrows of CALL_POINT = "VA02" and Value <> Blank.

I need the third measure which would return the countrows of Measure2 where the Value <> Measure1 Value.

Adding an example from my database. Usually, the VALUE corresponds to the CALL_POINT, but sometimes the Value is being manually changed on the column CALL_POINT = "VA02", so it can contain a different value than "Extracted or EX02", this can be seen in Line 2 and Line 5.

Let me know if I can somehow to simplify my question even more.

Regards,

Matas