Forum Discussion
Solved
Accumulated Measure using EARLIER and Inactive Relationship
Dear colleagueas, I'm trying to make this measure work for the past couple of days, but it seems over my head. I tried many things explianed elsewhere about accumulated measures, but it seems my ...
anmattos Forgot the ALL
Total Approval = VAR __Rev = MAX('fDCA'[Rev]) VAR __Table = ADDCOLUMNS( DISTINCT(ALL('fDCA'[Rev])), "__TotalApprovals",[Total Approvals] ) RETURN SUMX(FILTER(__Table,[Rev]<=__Rev),[__TotalApprovals])
anmattos Try:
Total Approval =
VAR __Rev = MAX('fDCA'[Rev])
VAR __Table =
ADDCOLUMNS(
DISTINCT('fDCA'[Rev]),
"__TotalApprovals",[Total Approvals]
)
RETURN
SUMX(FILTER(__Table,[Rev]<=__Rev),[__TotalApprovals])Hello Greg_Deckler ,
Thank you very much for the proposed solution. Unfortunately it returned the same results as my current formula.
Best regards,
anmattos Forgot the ALL
Total Approval = VAR __Rev = MAX('fDCA'[Rev]) VAR __Table = ADDCOLUMNS( DISTINCT(ALL('fDCA'[Rev])), "__TotalApprovals",[Total Approvals] ) RETURN SUMX(FILTER(__Table,[Rev]<=__Rev),[__TotalApprovals])Wow!!!
Thank you Greg_Deckler ! It worked! Now I´ll need more 3 days to understand it, but the problem is solved.
Thank you very much for your time!
