Forum Discussion
Calculating a running total on a dimensional string value
Hi everyone, I am working through an issue trying to create a running total based upon a String value in my dimension. I have a fact table with user records and a AgeSK value that links to a dime...
amitchandak
Super User
Super Userbender , I think the above should work for RetentionPeriod , as long as UnboundMonth is sortable.
You need a sort column for RetentionPeriod
This should work
CALCULATE(
[TotQualifiedUsers],
filter( ALL(Dim Table[UnboundMonth]) , Dim Table[UnboundMonth] >= max(Dim Table[UnboundMonth] ) ,
)
)
or
CALCULATE(
[TotQualifiedUsers],
filter( ALL(Dim Table[UnboundMonth]) , Dim Table[UnboundMonth] <= max(Dim Table[UnboundMonth] ) ,
)
)
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c