Forum Discussion
Solved
Cumulative Sum of ( Nested Calculated Max )
Hi,
i created dax to calculate cumulative max value ,
and i try to sum it ,but the sum is wrong,
any 1 can help ?
| Customer ID | YYYYWW | Penetration |
| 0013H000008gb63QAA | 202110 | 0 |
| 0013H000008gb63QAA | 202111 | 1 |
| 0013H000008gb63QAA | 202112 | 1 |
| 0013H000008gb63QAA | 202113 | 1 |
| 0013H000008gb63QAA | 202114 | 1 |
| 0013H000008gb63QAA | 202115 | 1 |
| 0013H000008gb64QAA | 202110 | 1 |
| 0013H000008gb64QAA | 202111 | 1 |
| 0013H000008gb64QAA | 202112 | 1 |
| 0013H000008gb64QAA | 202113 | 1 |
| 0013H000008gb64QAA | 202114 | 0 |
| 0013H000008gb64QAA | 202115 | 1 |
| 0013H000008gbB6QAI | 202110 | 0 |
| 0013H000008gbB6QAI | 202111 | 0 |
| 0013H000008gbB6QAI | 202112 | 1 |
| 0013H000008gbB6QAI | 202113 | 1 |
| 0013H000008gbB6QAI | 202114 | 0 |
| 0013H000008gbB6QAI | 202115 | 1 |
| 0013H000008gbbMQAQ | 202110 | 0 |
| 0013H000008gbbMQAQ | 202111 | 0 |
| 0013H000008gbbMQAQ | 202112 | 0 |
| 0013H000008gbbMQAQ | 202113 | 0 |
| 0013H000008gbbMQAQ | 202114 | 1 |
| 0013H000008gbbMQAQ | 202115 | 1 |
| 0013H000008gbBqQAI | 202110 | 0 |
| 0013H000008gbBqQAI | 202111 | 1 |
| 0013H000008gbBqQAI | 202112 | 1 |
| 0013H000008gbBqQAI | 202113 | 1 |
| 0013H000008gbBqQAI | 202114 | 1 |
| 0013H000008gbBqQAI | 202115 | 1 |
**bleep** Penetration2 =
var x= CALCULATE
(
MAX('Table 4'[Penetration]),
FILTER(
ALLSELECTED( 'Table 4'[YYYYWW]),'Table 4'[YYYYWW]<=max( 'Table 4'[YYYYWW])
)
)
var y =sumx('Table 4',x)
return y
Hi chin111 ,
Add an other measure as below.
Measure 2 = IF(ISINSCOPE('Table'[Customer ID]),[Penetration2],SUMX(('Table'),[Penetration2]))Best Regards,
jay
1 Reply
Hi chin111 ,
Add an other measure as below.
Measure 2 = IF(ISINSCOPE('Table'[Customer ID]),[Penetration2],SUMX(('Table'),[Penetration2]))Best Regards,
jay