How to get subtotals on particular category in Power BI

[Anonymous]

 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.

Power BI vs Excel

Thanks in Advance..

[Anonymous]

Hi @Anonymous,

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

[Anonymous]

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...