Forum Discussion

MageVortex's avatar
MageVortex
Helper 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
Community 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
Helper I
4 years ago
Sup Total = sum('Monthly Sup Count'[Supervisor Count])
This chart has data displayed like the following:

 

  • TheoC's avatar
    TheoC
    Community 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
      Helper I
      4 years ago

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

       

      • TheoC's avatar
        TheoC
        Community Champion
        4 years ago

        MageVortex - why does the fact tables have "Month" instead of date?  I noticed in the earlier data you provided, the Month column was a "Date / Time" format.  Can you change this to Date format only or is this like that for a reason?