Forum Discussion
Calculate Cumulative values on monthly
Hi, I have a table to calculate Cumulative value total on monthly for ecah year. I gave Visual level filter for 1 year (Find in below screenshot). Datatable has calender Date relationship with D...
It's not working as expected.
I notice some wierd thing -
1. I worte a measure for particluar value, it is working fine( without slicer).
Measure =
CALCULATE (
[Sum of financial],
FILTER (
ALL ( Financial ),
Financial[Month!] <= MAX ( Financial[Month!] )
&& Financial[Queue Name] = "OCOE-CRM-Task Resolution"
)
)
Right output :
Jan - 2,667
Feb - 5,334
Mar - 8,001
April - 10,668 .....................
2. I wrote same measure with storerd sclier selection value. (Slicer selection = SELECTEDVALUE(Financial[Queue Name]), and this measure i am in below measure as slicer slection value.
Measure 1 =
CALCULATE (
[Sum of financial],
FILTER (
ALL ( Financial ),
Financial[Month!] <= MAX ( Financial[Month!] )
&& Financial[Queue Name] = [Slicer selection]
)
)
Wrong output : calculating total of all values.
I am confused here, both measures are same. how they are caluclating values? if i specified in mesure it is working, if I am using sclier it is not working.
Help need
Help need
Try it with a variable.