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

PeterGarant's avatar
PeterGarant
Helper I
9 years ago

Bump, anybody had a chance to look at this? I still havn't found a good way to solve my problem :(

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi PeterGarant,

    After research, what part of your report will be dynamic according to your requirement?

    Best Regards,
    Angelia

    • PeterGarant's avatar
      PeterGarant
      Helper I
      9 years ago

      Hi v-huizhn-msft

       

      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.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        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