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.
Thanks in Advance..
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
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...