Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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.
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
@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
User | Count |
---|---|
50 | |
24 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |