Change measure calculation base on category selection

[Applicable88]

Hi,

I have a bar chart, with a typical datetable and the sum of duration of workload with following measure:

Workload =

(DIVIDE(CALCULATE(SUMX('Table','Table'[Duration]),24))

Its basically the workload percentage for one day.

Unfortunately when I just want to see the workload for one or two shifts after the selection of a shift category, to get the right values it should divide with 8 or respectively 16 hours, not 24 hours anymore. 

Help is much appreciated.

Thank you very much in advanced.

Best.

[AllisonKennedy · Accepted solution]

@Applicable88 

I think a DimShift or DimTime table might help here, but we need a bit more detail on how you want the 24 to change. 

Could you add the denominator info to your Shift table? For example 

Shift Category	Hours
A	8
B	8
C	8

Then divide by SUM(Shift[Hours]) 

If all shifts are selected it will divide by 24, if just 2 then 16, if just one, then 8. 

Not sure if your model is that simple? Let us know more details if this doesn't work or make sense.

[Applicable88]

@AllisonKennedy indeed a very straightforward approach. I thought too complicated and my approach would only work for selecting one Shiftcategory at a time or all, but not when I'm selecting two: 

WorkloadPerDay= DIVIDE(CALCULATE(SUMX('Table','Table '[Duration])),24)))

WorkloadPerEachCategory= DIVIDE(CALCULATE(SUMX('Table','Table '[Duration])),8)))

AuslastungProTagDynamicShift =

IF(HASONEFILTER('Table'[Shiftcategory]),

SWITCH(SELECTEDVALUE('Tble)'[Shiftcategory]),

"A", [WorkloadPerEachCategory],

"B", [WorkloadPerEachCategory],

"C", [WorkloadPerEachCategory]

),

([WorkloadPerDay])

)

Thanks again.

Best regards.