Forum Discussion

MageVortex's avatar
MageVortex
Icon for Helper I rankHelper I
4 years ago

Rolling Average quick measure breaks with Card Visualization

Hello, I have a quick measure to calculate a rolling average. It was working last month, but now in January, the Card visual shows a 'Blank' value instead of the actual value. When I place the measu...
Need Help
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi MageVortex 

 

How have you structured your date table?  A lot of times, when a date table is first created, manual inputs are used on the start and end dates.  I recommend checking the end date to ensure it has rolled over into 2022.

 

Hope this helps.

Theo 🙂

  • MageVortex's avatar
    MageVortex
    Icon for Helper I rankHelper I
    4 years ago

    It is set up the same way, goes out +60 days from todays present day (pulls from a table that goes out a few years) so the set up is consistent. I made sure the set up was consistent.

    • TheoC's avatar
      TheoC
      Icon for Community Champion rankCommunity Champion
      4 years ago

      That's good to hear!  With regard to your main measure, what is your [Sup Total] value? It is used in your current measure in the first line: "if(CALCULATE([Sup Total])=0,BLANK()"

      • MageVortex's avatar
        MageVortex
        Icon for Helper I rankHelper I
        4 years ago
        Sup Total = sum('Monthly Sup Count'[Supervisor Count])
        This chart has data displayed like the following: