Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |