Dax_rankx_sum_total

DAX DAX Calculations
1

Hi guys,

I need to put in a measure what you see in the picture so the measure provide me with the sum of RANK 20 per peer. The idea is that. Basically I need the top 20 ranked institutions per CY (Current Year) and Peer.

The measure should give me the Total you see below in the pic this case for Barclays

See pic,

RANKX
RANKX1478×517 53.2 KB

Any help!!!

Thanks F Pastor

1 Like
2

Hi,

It will be really helpful in providing answerer if you upload a powerbi file of your above question.

Thanks,
Anurag

2 Likes
3

Hi,

As i see in your pic you have a rank measure Then you can try the below Type of measure:

Calculate([yourmeasure],Filter(All(table[Intitution]),[rank]<21)

For accurate answerer i need to see your pbix.

Thanks,
Anurag

1 Like
4

Thank you Anura, I can’t load a copy of the file I am afraid.

F Pastor

1 Like
5

I try this one, thanks a lot

F pastor

1 Like
6

Ok let me know if this solve your query.

1 Like
7

So far is working well, thanks a lot.

F Pastor

1 Like