Forum Discussion

Matas's avatar
Matas
Icon for Advocate II rankAdvocate II
4 years ago

Comparing Two measure with each other

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

DAX
DAX Calculation
DAX Commands
Help me please

2 Replies

    • Matas's avatar
      Matas
      Icon for Advocate II rankAdvocate II
      4 years ago

      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