Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power Geeks,
I am looking for Grouping by SUM, And Sum for each dynamic group (Store ID),similar to SSRS or Crystal Reports.
Currently the Report looks like:
INVOICE | PRICE | Store ID |
202303 | 4.381623 | 34 |
202303 | 641.7039 | 5 |
202303 | 641.7382 | 5 |
202303 | 3838.188 | 21 |
202303 | 5552.746 | 235 |
202303 | 5294.524 | 678 |
202303 | 524.124 | 678 |
And I want the output like:
INVOICE | PRICE | Store ID |
202303 | 641.7039 | 5 |
202303 | 641.7382 | 5 |
TOTAL for 5 | 1283.442 | |
202303 | 3838.188 | 21 |
TOTAL for 21 | 3838.188 | |
202303 | 4.381623 | 34 |
TOTAL for 34 | 4.381623 | |
202303 | 5552.746 | 235 |
TOTAL for 235 | 5552.746 | |
202303 | 5294.524 | 678 |
202303 | 524.124 | 678 |
TOTAL for 678 | 5818.648 |
Users wanted in Power BI Desktop, All they needed is Totals for each Group. So, I need Grouping on Store ID and Sum By Price for each Store.So,Can we tweak atleats like below in Power BI Desktop?
INVOICE | PRICE | Store ID |
202303 | 641.7039 | 5 |
202303 | 641.7382 | 5 |
1283.442 | ||
202303 | 3838.188 | 21 |
3838.188 | ||
202303 | 4.381623 | 34 |
4.381623 | ||
202303 | 5552.746 | 235 |
5552.746 | ||
202303 | 5294.524 | 678 |
202303 | 524.124 | 678 |
5818.648 |
If the Matrix visual is not satisfying, you may use SUMMARIZE Function to add a calculated table.
Hi,
I cannot get your desired result using Power BI desktop. Using Excel, i can get a close enough result (see screenshot). In Excel, i have used Power Query (the Index column has been generated using Power Query) and Pivot Tables to get your desired result.
Hmm, I can seem to get close with the new Table and Matrix but can't get it exactly like you want below, would be interested if anyone else can think of a solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |