Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
Assuming I want to filter out a few out of many customers in a data set (C1-C1000), and I want subtotals like below, how do I create the "Total" and "Total of other customers" calculations? Any help would be greatly appreciated!
Revenue | % of Rev (rev / total of all customers) | |
C23 | 5 | 5% |
C45 | 10 | 10% |
C22 | 15 | 15% |
Total of above | 30 | 30% |
Total of other customers | 70 | 70% |
Total of all customers | 100 | 100% |
Solved! Go to Solution.
Hi @mengna
You may use ALL Function like below:
Total of all customers = CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
Total of other customers = CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) ) - SUM ( 'Table'[Revenue] )
Regards,
Hi @mengna
You may use ALL Function like below:
Total of all customers = CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
Total of other customers = CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) ) - SUM ( 'Table'[Revenue] )
Regards,
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |