Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a matrix with 10 levels (or rows), it is a hierarchy.
I want to do a measure like:
Cost:=
VAR Sumat = [FixedCosts]+[VariableCosts]
Return
SWITCH (
TRUE (),
--lowest level
Sumat,
--9th level
ISINSCOPE ( Project[level9] ), IF (Sumat <0, 0, [Sumat]),
--8th level (from this point on the aggregation should be the classic SUM)...
ISINSCOPE ( Client[Comp] ), --just sum as usual
...
)
That is, (from lowest to uppest level...
.... and so on
Can this be achieved in DAX?
@Anonymous See if this helps: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |