Forum Discussion
bhelou
Responsive Resident
Responsive ResidentLAST NON BLANK
Dear ,
I have this measure ( below ) , calculation for it in the rows inside the table is correct , but in the summation it is refereing to the last non blank value that i have , it is not summing it up , kindly if you can help with modifying the measure , thanks
Cost =
VAR COST =
ROUND(CALCULATE (
LASTNONBLANK(
XXAWPT_FA_DEPRN_SUMMARY[ADJUSTED_COST],
XXAWPT_FA_DEPRN_SUMMARY[ADJUSTED_COST]
),
XXAWPT_FA_DEPRN_SUMMARY[DEPRN_SOURCE_CODE] = "DEPRN",
FILTER (
XXAWPT_FA_DEPRN_SUMMARY,
XXAWPT_FA_DEPRN_SUMMARY[DEPRN_RUN_DATE]
= MAX ( XXAWPT_FA_DEPRN_SUMMARY[DEPRN_RUN_DATE] ))),0)
RETURN
ROUND(CALCULATE (
Cost,
FILTER (
ALL ( '*Dates' ),
'*Dates'[Date]
<= MAX ( '*Dates'[Date] )
)
),0)
Thank you
Thank you
3 Replies
- amitchandak
Super User
Hi bhelou ,
This is a common issue.
I tried to reproduce your issue. The total should be 7 not 5.
You can create a new measure using ISINSCOPE to solve.
Measure = IF(ISINSCOPE('Table'[Month]),[Cost],SUMX('Table',[Cost]))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bhelouThank you very much it worked , 1 M kudos , thank you amitchandak
