Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
tamerj1
Super User

Hi Matas 
Here is a sample file with the solution https://we.tl/t-36zvTh2N5O

Doc. Count = 
VAR EXTable = 
    FILTER ( Extracted, [CALL_POINT] = "EX02" )
VAR VATable = 
    FILTER ( Extracted, [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] )
RETURN
    COUNTROWS ( T4 )