Forum Discussion

vijaykumarj19's avatar
vijaykumarj19
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Cumulative total for no data

attribute value x1 12 x2 22 x3 31 x4 0 x5 0   cummulate total    CALCULATE(     SUM(Table[value]),         FILTER(         ALLSELECTED(table[attribute]]),       ...
DAX
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

vijaykumarj19 , Try if this can work

CALCULATE(
SUM(Table[value]),
FILTER(
ALLSELECTED(table[attribute]]),
ISONORAFTER(table[attribute] , MAX(table[attribute]) , DESC) && Table[value] >0
))

vijaykumarj19's avatar
vijaykumarj19
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Value i have is a measure