cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
anikah Regular Visitor
Regular Visitor

How to get subtotals on particular category in Power BI

 Hello,

 

I want to get subtotals for a perticular category. Described clearly in the excel screen shot with the yellow highlighted part for totals  on each district for each product seperatly. Want to see same kind of totals in Power BI. Please let me know how to achieve this.

 

 

ScreenShot.PNGPower BI vs Excel

 

Thanks in Advance..

2 REPLIES 2
NickNg278 Senior Member
Senior Member

Re: How to get subtotals on particular category in Power BI

Hi @anikah,

Have you considered having two different views of your table? The first view would be your current table in Power BI, and the second view would only have City, Prod, Sales, % Project columns

anikah Regular Visitor
Regular Visitor

Re: How to get subtotals on particular category in Power BI

Thanks for the response,

 

Good idea to keep seperate table for district totals. But i would like to know is there a way can we  provide  totals within the main table with DAX formula...