Forum Discussion

Mattbidev101's avatar
Mattbidev101
Icon for Helper I rankHelper I
5 years ago

Filter on Cumulative YOY graph not working

I have this report that you see here with an issue on my cumulative graph.  When you hover over the bar in the cumulative revenue graph, you'll see that the cumulative revenue tooltip doesn't match t...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

I have edited the formula in my solution file i shared with you earlier.  Download the revised file from here.

Hope this helps.

Mattbidev101's avatar
Mattbidev101
Icon for Helper I rankHelper I
5 years ago

I appreciate you sticking with me!  However it's still not working rolling up cumulative. this dax that you shared:

Cumulative revenue1 = IF(ISBLANK([Revenue]),BLANK(),CALCULATE([Revenue],DATESYTD(Dates[Date],"30/6")))
 
and the dax i used:  
Cumulative revenue1 = IF([Revenue] = 0,"",CALCULATE([Revenue],DATESYTD(Dates[Date],"30/6")))
 
should function the exact same way.  I'm missing something else that you are doing in your file to make this work.  Can you see what I'm missing in the file I shared?  When you shared your solution the first time, i tried to find everything that you did but I must have missed something important.
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Why can you not just apply my formula?  I have spent quite some time in framing that solution and would not like to devote any more time in identifying the problem in your file.  Hope you understand.  Thank you.

  • Mattbidev101's avatar
    Mattbidev101
    Icon for Helper I rankHelper I
    5 years ago

    I did apply that formula to make sure.  It doesn't work.  Is there something else that you did besides just that function?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    No, i did not.

  • Mattbidev101's avatar
    Mattbidev101
    Icon for Helper I rankHelper I
    5 years ago

    Ok thanks for trying.  You've given me some stuff to look at least.  If i manage to solve it I'll publish something for anyone interested.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Thank you for your understanding.  I would have looked at your file had i already not spent enough time in framing the original solution.  Furthermore, in the file that i shared with you, it is working absolutely fine.  Compare the Calendar table and the relationships.

  • Mattbidev101's avatar
    Mattbidev101
    Icon for Helper I rankHelper I
    5 years ago

    I will thanks