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.