Forum Discussion

sullynivek's avatar
sullynivek
Frequent Visitor
9 years ago
Solved

find percent from grouped data

Hi,   I have a table that I have grouped the data by the following headings:   Planned Absence Reactive Breakdowns Damage   With Power BI creating the total. The grouped data is the amount ...
  • sullynivek's avatar
    sullynivek
    9 years ago

    All,

     

    Just for information here is the solution:

     

     

    Measure = DIVIDE(SUM('Emtc joined with wkaw'[hrs]),CALCULATE(SUM('Emtc joined with wkaw'[hrs]), ALLSELECTED('Emtc joined with wkaw'[Weekly Utilisations])),0)

sullynivek's avatar
sullynivek
Frequent Visitor
9 years ago

Apoligies for the messy data, essentially what I am trying to accomplish is to group by work type and produce weekly hours from the date slicer as mentioned in my first post. this is all fine, what i am struggling with is to get the percentages, would this be done on the raw data from creating a new column or is the a way of calculating it from within the grouping?

 

Kevin

sullynivek's avatar
sullynivek
Frequent Visitor
9 years ago

All,

 

Just for information here is the solution:

 

 

Measure = DIVIDE(SUM('Emtc joined with wkaw'[hrs]),CALCULATE(SUM('Emtc joined with wkaw'[hrs]), ALLSELECTED('Emtc joined with wkaw'[Weekly Utilisations])),0)