Forum Discussion

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

DAX Comparing Columns and Vs

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 c...
DAX
Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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 )
  • Matas's avatar
    Matas
    Icon for Advocate II rankAdvocate II
    4 years ago

    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