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

CahabaData's avatar
CahabaData
Memorable Member
9 years ago

I think the approach to use involves how you define/determine age.  It's odd to see a negative number - and that same thing is what is causing you problems.  So I would change that approach rather than attempt to resolve it via filters or measures up in the visual level.

 

Typically for machinery aging there is a Start or In Service date - - and then its age is calculated dynamically off of that.  The calendar function will know when it is a leap year so there's no problem there; and if you want to carve out weekends to get a more true in-service age rather than calendar age - - that is possible too.

 

You'll never have a negative number and this should scale to all of your visuals without further problems.

  • PeterGarant's avatar
    PeterGarant
    Helper I
    9 years ago

    Hi CahabaData

     

    The problem is that in this example I am looking at sales from 2016, but i have one item that wasn't created until 2017, so I want it to be in my data, but just not be calculated in the 2016 report. But in the future I would like to make the report dynamic, so that is why i don't want to filter it out in the dataset.