topic Re: How to havea subtotal in the chart in DAX Commands and Tips

How to havea subtotal in the chart

Anonymous — Thu, 03 Sep 2020 07:23:19 GMT

Hello , i need to create a pivot table,the last row is the total, we need to create a second lin with the partial total for one filter is it possible?thank you

Re: How to havea subtotal in the chart

amitchandak — Thu, 03 Sep 2020 07:52:29 GMT

Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

But allexcept should help. refer these two

https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

Re: How to havea subtotal in the chart

Greg_Deckler — Sun, 06 Sep 2020 13:56:11 GMT

Anonymous - Can you at least share a mock-up image of what you are trying to achieve?

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: How to havea subtotal in the chart

Anonymous — Mon, 07 Sep 2020 14:34:37 GMT

Thank you for your answer, of course,

I need to create a Pivot table as below:

and is ok for every value but if i need to add the last row wth the count of number of intervent with PEC how can i do it? because is a second value and i shuldn't add it as column but only with the total as last row

Pivot table:

Row:Unità

column:Month

Value:Qty, qty x PEC (these 2 value are different measure)

thank you Massimiliano