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.
Hello All. This seems like it should be very simple, but I can't figure it out. I have a Matrix like so
First three columns are in one table, Labor Spent in another and Delta is a measure:
Solved! Go to Solution.
Hi @AMPAllie ,
Please refer this formula:
RunningTotal =
SUMX (
ALLEXCEPT (
'PR PH TS Names and Budget',
'PR PH TS Names and Budget'[PR#],
'PR PH TS Names and Budget'[PH#]
),
[Delta]
)
Or
RunningTotal =
SUMX (
FILTER (
ALLSELECTED ( 'PR PH TS Names and Budget' ),
'PR PH TS Names and Budget'[PR#]
= SELECTEDVALUE ( 'PR PH TS Names and Budget'[PR#] )
&& 'PR PH TS Names and Budget'[PH#]
= SELECTEDVALUE ( 'PR PH TS Names and Budget'[PH#] )
),
[Delta]
)
If it still doesn't work, please share some sample data.
Best Regards,
Jay
Hi @AMPAllie ,
Please refer this formula:
RunningTotal =
SUMX (
ALLEXCEPT (
'PR PH TS Names and Budget',
'PR PH TS Names and Budget'[PR#],
'PR PH TS Names and Budget'[PH#]
),
[Delta]
)
Or
RunningTotal =
SUMX (
FILTER (
ALLSELECTED ( 'PR PH TS Names and Budget' ),
'PR PH TS Names and Budget'[PR#]
= SELECTEDVALUE ( 'PR PH TS Names and Budget'[PR#] )
&& 'PR PH TS Names and Budget'[PH#]
= SELECTEDVALUE ( 'PR PH TS Names and Budget'[PH#] )
),
[Delta]
)
If it still doesn't work, please share some sample data.
Best Regards,
Jay
Hi @AMPAllie
please try
Running Total =
VAR CurrentPH =
SELECTEDVALUE ( TableName[PH#] )
VAR T1 =
CALCULATETABLE (
VALUES ( TableName[PR#] ),
ALLEXCEPT ( TableName, TableName[PH#] ),
ALLSELECTED ( TableName )
)
VAR T2 =
FILTER ( T1, TableName[PH#] <= CurrentPH )
RETURN
SUMX ( T2, [Delta] )
That returned this:
I found my typo...corrected it. But now I get an error. I should have mentioned...the PH# values are not unique. They repeat over and over.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |