Change occupation in days to occupation in %

[Anonymous]

Goodmorning,

I'm working on a report to show the occupation of certain machines in days. I have a Start Date and End Date linked to a calender, and got the count of days in the slicer working correctly. But i'd like to show the data in percentages.

I want to filter in years, months and weeks. So for instance in week 42 of 2018 when a machine is occupied for 7 days the occupancy should be 100%. If it is possible i want the data at the bottom of the bar to show the occupancy in a percentage.

And when i change the filter to a month, it should calculate the occupancy in days/month.

Thanks in advance for any help!

[yelsherif · Accepted solution]

Please provide sample data table to be able to understand correctly.

Instead of using the data directly from the table, you can create a measure that follows your filter selection.

Something like

SelectionMeasure =

      if(isfiltered(monthSlicerTable),

             divide(distinctcount(datatable[days],

                        day(

                               date(

                                        selectedvalue(yearSlicerTable[year]),

                                        selectedvalue(monthSlicerTable[month])+1,

                                        1
                              )-1),
                       0),

             divide(distinctcount(datatable[days], 7, 0)

      )

Then you can use the measure in your visual

[Anonymous]

The table at the top right is the data i'm working with. I editted out some "secret" info.

As i filter the count of date changes to the amount of dates it is occupied in that given periode.

Will look into your dax formula to see if i can work it out.