Forum Discussion
prakash11440278
Post Prodigy
5 years agoGrand Total substract with previous record count
Hi Team, Please share the dax expression for the below requirement.
- 5 years ago
Thank you for the data.
You can create a measure using the following formula.
It will be best if you create a calculated column by summing up all the columns in every row. to get total roll up amount
Total =
VAR totalvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ), REMOVEFILTERS ( 'Table' ) )
VAR monthvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ) )
VAR Total =
IF ( ISBLANK ( monthvalue ), BLANK (), totalvalue )
VAR CurrentDate =
MAX ( 'Table'[Month] )
VAR rollupYTD =
CALCULATE (
SUM ( 'Table'[RollUp] ),
FILTER ( ALL ( 'Table' ), 'Table'[Month] < CurrentDate )
)
VAR result = Total - rollupYTD
RETURN
resultYou can get result as follows
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
sayaliredij
Solution Sage
5 years agoThank you for the data.
You can create a measure using the following formula.
It will be best if you create a calculated column by summing up all the columns in every row. to get total roll up amount
Total =
VAR totalvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ), REMOVEFILTERS ( 'Table' ) )
VAR monthvalue =
CALCULATE ( SUM ( 'Table'[RollUp] ) )
VAR Total =
IF ( ISBLANK ( monthvalue ), BLANK (), totalvalue )
VAR CurrentDate =
MAX ( 'Table'[Month] )
VAR rollupYTD =
CALCULATE (
SUM ( 'Table'[RollUp] ),
FILTER ( ALL ( 'Table' ), 'Table'[Month] < CurrentDate )
)
VAR result = Total - rollupYTD
RETURN
result
You can get result as follows
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.