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

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

Hi PeterGarant,

 

Do you mind share your resource table or .pbix file for further analysis? It's hard to reproduce your scenario wittout sample table.

 

Best Regards,
Angelia

  • PeterGarant's avatar
    PeterGarant
    Helper I
    9 years ago

    Hi v-huizhn-msft

     

    Here is a link to the file:

     

    https://www.dropbox.com/s/radpououmbyz1oh/Bel%C3%A6gningsgraderMedDage.pbix?dl=0

    Thank you for any insight you might be able to provide. And sorry for the danish words here and there :)

     

    I can easily take out the sinner from the data, but as I wrote earlier, I would like to be able to filter it out in the report instead of the in the data, as I would like to make it more flexible in the future.