Forum Discussion
sandeepk66
Advocate I
Advocate IPower BI Desktop Sum By Group
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 ...
sandeepk66Advocate I
Advocate IUsers 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 |
v-chuncz-msft
Community Support
Community Support
If the Matrix visual is not satisfying, you may use SUMMARIZE Function to add a calculated table.