Forum Discussion

arp2's avatar
arp2
Icon for Helper II rankHelper II
2 years ago
Solved

Help with slicer measure

Team, I have three tables showing weekly forecast, capacity, and plan by discipline, Project, and Grouping. I've created measures for the Average of the Top 5 weeks (for Forecast) and Max of Capacity...
Need Help
Kaviraj11's avatar
Kaviraj11
Icon for Solution Sage rankSolution Sage
2 years ago

For the 1st Problem - you can change the following Measure to 

 

SumFcstWeek = CALCULATE(SUM(ForecastTable[Forecast Hours]))
AvgTop5Weeks = AVERAGEX(TOPN(5,SUMMARIZE(ALLSELECTED(ForecastTable),ForecastTable[Week],"TotWeek",[SumFcstWeek]),[TotWeek],DESC),[TotWeek])
  • arp2's avatar
    arp2
    Icon for Helper II rankHelper II
    2 years ago

    Thanks Kaviraj11 would you be able to guide on the 2nd point?