Forum Discussion
Solved
Utilization rate
Hi all I'm still pretty new to Power BI, so there might be a very simple solution for my problem. I'm trying to calculate the utilization rate of some of our items. I've made it so that it ta...
Hi PeterGarant,
If you select 2016, you need to add a [year] as slicer. Then create a measure using the similar formula.result=CALCULATE([total],Filter(Table, Table[year]<=ALLSELECTED(Date[year])))
Don't hesitate to ask if you have any questions.
Best Regards,
Angelia
Well, right now I'm only selecting for 2016, but in the end I would like to have all years or at least from 2004 in the data. So figureing out how to make it dynamic, and then for each year would be the goal in the end. But right now it's more just to figure out how to make the totalts correct.
Hi PeterGarant,
If you select 2016, you need to add a [year] as slicer. Then create a measure using the similar formula.
result=CALCULATE([total],Filter(Table, Table[year]<=ALLSELECTED(Date[year])))
Don't hesitate to ask if you have any questions.
Best Regards,
Angelia