Forum Discussion

JB's avatar
JB
Icon for Helper II rankHelper II
4 years ago

Date Filtered Calculation Not Working As Expected

I have three measures on a report that calculate stock value and the change in stock value on a monthly basis. They need to be receptive to two slicers; a date slicer and a Component Type slicer. The...
CALCULATE
Filter
if
Slicer
sum
variable
JB's avatar
JB
Icon for Helper II rankHelper II
4 years ago

That probably is the more sensible option, I went off what I already knew which is why it's maybe not the most intuitive coding. I'll bear your advice in mind for the future though, thanks.

Do you have any ideas why the expressions above are behaving differently despite being practically identical?

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Maybe you can change your slicer to Year-Month, in the event you are only using month and you have multiple years?

 

I generally use the simple index methode it's easier to follow and each month only has oe value during a calculation.

 

DAX Studio is a good place to try out the scenarios though.

  • JB's avatar
    JB
    Icon for Helper II rankHelper II
    4 years ago

    My slicer is for Month-Year, and I only have three months worth of data in there so far as it's a new dashboard to be rolled out this year. Besides, the other measures use the same time intelligence logic and work fine.