Forum Discussion

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

DAX Comparison between tables

Hi,   I am having an issue and cannot figure it out, since I am still pretty new on DAX. Currently, I am having a table in the database, where it stores the "Extracted" documents that have been aut...
DAX
DAX Commands and Tips
Help Requested
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Matas 
    Pleas etry this code

    Document Count = 
SUMX (
    SUMMARIZE ( 'Raw Data','Raw Data'[REGID], 'Raw Data'[DOCID] ),
    CALCULATE (
        VAR EXTable = 
            FILTER ( 'Raw Data', [CALL_POINT] = "EX02" )
        VAR VATable = 
            FILTER ( 'Raw Data', [CALL_POINT] = "VA02" )
        VAR T1 =
            ADDCOLUMNS ( EXTable, "@Rank", RANKX ( EXTable, [Index],, ASC, Dense ) )
        VAR T2 = 
            ADDCOLUMNS ( 
                T1, 
                "@Value", 
                VAR CurrentRank = [@Rank]
                VAR T3 = TOPN ( CurrentRank, VATable, [Index], ASC )
                RETURN
                    MAXX ( T3, [VALUE] )
            )
        VAR T4 = 
            FILTER ( T2, [VALUE] <> [@Value] )
        VAR T5 = SELECTCOLUMNS ( T4, "@DOCID", [DOCID] )
        RETURN
            COUNTROWS ( DISTINCT ( T5 ) )
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Matas 

Is it me who wrote that measure? It ssems that O don't fully understand your requirement for the validation measure. I prefer to connect via teams or zoom perhaps on Monday. It is really difficult in some cases to auther codes without having your hands on the real data. 

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

Hi tamerj1 ,

 

Yes, it was you who helped me with this measure as well. 

This sounds great, how could we connect via teams? Could you send me a private message?

And sorry that I cannot publish pbix file or show the full data behind it. This is data from the client, so I am not allowed to do so.

 

Regards,

Matas