March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
82 | |
69 | |
53 | |
44 |
User | Count |
---|---|
202 | |
106 | |
100 | |
64 | |
56 |