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

MageVortex 

 

As good as Power BI is, setting up a calendar in that manner unfortunately will not work very effectively unless relationships and relevance have been established.  Instead of working on Dates, Calendars, etc., can you tell me what is the outcome that you are trying to achieve?  By this, I mean, what is "roll6SupTo no ReOrg" trying to calculate?

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

The total/overall average of the 6 month rolling average of the Supervisor turnover excluding a certain segment of those supervisors.  As the original image shows, it still calculates it, but now it won't display in the KPI box.
This is what it looks like pre 2022

 

This is it now

Again, if I change the date range to be before 1/1/2022, it works, but once I include 2022, it no longer generates that total.