Count Top 1 Rank per day

Anonymous 

this is the sample data i have used: 

result : 

power bi result : 

measure : 

rank measure = 

rnk = 
RANKX(
    ALLSELECTED(tbl_rank[Team]),
    [total points],
    ,DESC
)

nb of days measure

nb of days n1 = 

var ds = 
ADDCOLUMNS(
    CALCULATETABLE(
    SUMMARIZE(
        tbl_rank,
        tbl_rank[date],
        tbl_rank[Team]
    ),
    ALLSELECTED(tbl_rank[Team])
    ),
    "@r" , [rnk]
)


var s = 
GROUPBY(
    ds,
    [@r],
    tbl_rank[Team],
    "c", COUNTX(CURRENTGROUP() , 1 )
)

return 

SUMX(
    
    FILTER(
        s,
        tbl_rank[Team] in VALUES(tbl_rank[Team]) && [@r] = 1 
    ),
        [c])

hope this works for you .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠