Forum Discussion
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]]),
ISONORAFTER('table[attribute] , MAX(table[attribute]) , DESC)
))
its showing cumulative for o values also , need to exclude cumulate where there is no value
2 Replies
vijaykumarj19 , Try if this can work
CALCULATE(
SUM(Table[value]),
FILTER(
ALLSELECTED(table[attribute]]),
ISONORAFTER(table[attribute] , MAX(table[attribute]) , DESC) && Table[value] >0
))Value i have is a measure
