Summarize and Rank by multiple columns and rows

[Kitkat]

Total Revenue	Client Name	Year	Month	Revenue Stream
-1625.7	ABC	2016	10	1
-11693.9	DEF	2016	10	2
-598.79	GHI	2016	10	3
-523.52	JKL	2016	10	1
-84.85	MNO	2016	10	2
-8284.16	PQR	2016	10	3

I am trying to create a formula that would take in this order:(Sum of- TotalRevenue by Client Name and Revenue Stream), then i want to rank highest to lowest within each revenue stream by sum of Total Revenue by client

Help super new to DAX- thanks all

[v-chuncz-msft · Accepted solution]

@Kitkat,

You may use SUMMARIZE Function to add a calculated table and then use RANKX Function to add a calculated column. The post below is for your reference.

https://community.powerbi.com/t5/Desktop/how-can-I-show-top-3-data-with-a-combined-categories/td-p/1...