Forum Discussion

PeterGarant's avatar
PeterGarant
Helper I
9 years ago
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...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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