How to havea subtotal in the chart

[Anonymous]

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 

[Greg_Deckler]

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

[Anonymous]

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

[amitchandak]

@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