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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
davekoeper
Regular Visitor

Subtotal Percentages

I have a spreadsheet with percentage increases for different cities, territories, states, store types, etc. I have the subtotals set up in Excel but can't figure out how to transfer into PowerBI. PowerBI is just showing the average of the percentages and not the percentage for each filte . Can someone assist?

 

2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @davekoeper,

 

Have you tried the suggestion provided by @freder1ck above? Do you still have any question on this issue?

 

If yes, could you post your table structures with some sample/mock data(do mask sensitive data) and your expected result? So that we can better assist on the issue. Smiley Happy

 

Regards

freder1ck
Kudo Kingpin
Kudo Kingpin

Dave, 

 

It sounds like you may need a SUMX of the percentage over the city list (and each of the other lookup tables). Are you using any measures or are you trying to do it all with visualizations? 


@davekoeper wrote:

I have a spreadsheet with percentage increases for different cities, territories, states, store types, etc. I have the subtotals set up in Excel but can't figure out how to transfer into PowerBI. PowerBI is just showing the average of the percentages and not the percentage for each filte . Can someone assist?

 


 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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