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:

       

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

        Hi MageVortex 

         

        Okay, I think it may have to do with the current structure of your model and the relationships between your fact table and date table.  Are you able to send me a screenshot of the Model view screen that shows the relationships?

         

        Thanks heaps mate. 

        Theo 🙂