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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
liztruong
Frequent Visitor

Rank values based on the slicers from another table

Hi everyone, I need your help!!!

 

I have 2 tables: Sales and Services. Now I want to rank SumSales per Products by selecting the Services. The table needs to have 4 columns: Rank, Products, Services, SumSales. I did make a measure like this:

 

rank = RANKS(CROSSJOIN (ALL(Sales[Products]), ALLSELECTED(Services[Name]), [SumSales], , DESC)

 

But it doesn't work. Anyone can help me? Thank you much

1 REPLY 1
amitchandak
Super User
Super User

@liztruong , If they are joined with each other

 

Try like

rank = RANKX(Summarize(ALL(Sales),Sales[Product],Services[Name]), [SumSales], , DESC)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors