Forum Discussion

Namoh's avatar
Namoh
Icon for Post Partisan rankPost Partisan
6 years ago
Solved

Adding WHERE MAX statement into DAX measure TOTALYTD

Hi.   I’ve got a DAX measure which calculates the TOTALYTD: YTD_Unplanned_Downtine_Target = IF( SUM(Targets[Target Unplanned downtime (hrs)]) = BLANK(); BLANK ();TOTALYTD(SUM(Targets[Target Unplann...
Need Help
  • Namoh's avatar
    Namoh
    6 years ago

    Ok, so to be honest, I don't know what I did to make it work, but it works!

     

    I was fooling around with some fields (Calendar-Date vs Targets-Begin van de maand), I was adding a Filter onto measure _5_ stating show all that's Not Empty, I clicked in the table in the right top corner on Zoom Out and Expand 1 level in Hierarchie, etc and now it shows:

    1. just the values of the beginning of the months

    2. it summarizes after each month

    3. it stops after the current month

     

    Thanks for your help.

     

     

     

     

Namoh's avatar
Namoh
Icon for Post Partisan rankPost Partisan
6 years ago

Well I've created the measures instead as columns and now I don't get an error?

 

Someone must explain to me what the difference is between these two options, because I expected the same outcome (with the same formula) but apparently with the column option I get an error but with the measure option it works fine...?

 

So I've created the report but it's not taking into account the FY, starting at april nor does it not show the future months.......

 

I'm still at the same level as my original post.

 

  • Namoh's avatar
    Namoh
    Icon for Post Partisan rankPost Partisan
    6 years ago

    Thanks, this gives a bit more insight.

     

    Anyone who can help me with my original issue, still not working as expected.