Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |