Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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 )