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
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 🙂

       

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

        This may confuse more than help when I draw the arrows to show the connections