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 , I need to build a matrix table with a couple of dimensions on it. This is the structure of the table :
I know that I can get line 3 with a dimension that groups lines 1 and 2 (same with line 6). But what about line 7 (which is the result of line 3 - line 6) ?
So my goal is to have a couple of calculated subtotals that sometimes grab different lines from the report. Which is the best way to achieve this?
Thanks
@Anonymous
Are you working with power bi? I don't really understand how you are calculating using DAX.
Can you provide a sample table of what you have now, and then provide another expected output table?
Regards
Paul
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |