cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srini_kris Frequent Visitor
Frequent Visitor

Re: Show Top N and sum up the Others as a value

Hi  Parry2K 

 

 

 

 

 

 

 

 

raviku Frequent Visitor
Frequent Visitor

Re: Show Top N and sum up the Others as a value

I Have 2 Columsn Products and sales. I want to get Top 5 rows  Dynamically and rest 5 as sum value in a single row. Can you please help me achive this. I was trying out the Steps but could not get it done.

ProductSales
A3
B4
C1
D5
E7
F8
G12
H9
I2
K10
raviku Frequent Visitor
Frequent Visitor

Re: Show Top N and sum up the Others as a value

Can you please let me know how have got the column in Total with Other Measure after If condition.

if([rank]>10, table[cloumn name].

This is not right syntax right. Can you please correct me.

freiburgc Regular Visitor
Regular Visitor

Re: Show Top N and sum up the Others as a value

Hallo @parry2k ,

your solution almost worked for me as well.

 

But I still don´t get the solution I need.

 

Top10Products.png

I get my Top 10 Products and the Rest (Sonstige), but sum is just the sum of Top 10 Products. But it should be round about 43 Millions.

I just changed the first measure, instead of Values I used Distinct. With Values I get circular dependencies.

 

All other measures like your measures.

 

I am thankfull for every help!

Christian

 

 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,991)