Data Modelling

[tsarun1992]

Hi All,

My query is very simple.

I have the data as following.

PO Number - XXXXXXXXX - 4320 Hours for that PO. There are two resources assigned to work in that PO.

2160 Hours for each resource is allocated in which,

Resource 1 - 1779 Hours used  

Resource 2 - 1705 Hours used

So the total hours used is 3484 Hours (80.60% Utilized - 3484/4320)

This % used is shown perfectly when I select the PO (As it has the total hours booked under it)

But when I choose the resource, instead of taken PO hours for that resouce to calculate the utilization %, it takes the total hours.

For Resource 1, its 1779 Hours against 2160 hours (Approx 82%) but it shows as 41.2% which is 1779/4320 (Shown below)

The formula used to calculate that % is as below,

I had used quick measure to calculate this. Instead, should I use any other DAX using some filter?

Please guide.

[v-jialluo-msft · Accepted solution]

Hi  @tsarun1992 ,

You can try this:

PO Burn Rate = 
DIVIDE(
SUM( 'ENABL IN PO NAV Hours'[NAV Hours]),
CALCULATE(SUM( 'ENABL IN PO'[PO Hour]),ALL('ENABL IN PO'))
)

If that's not what you need, provide sample files and expected output.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Gallen Luo