Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

Working Days as Filter

Hi,   I have the following code that calculates the Total Days duration of X.     Case Length (Adj) = IF ( 'Cases'[statecode] = "Active", DATEDIFF ( IF ( ISBLANK ( ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  ArchStanton ,

 

If you want the Total row to not change with it, you can create a dummy table and then use IF+ HASONEFILTER() to determine if the Total

Measure 2 =
var _table=
SUMMARIZE(
    ALL('Cases'),[Team Name],"Value1",SUMX('Cases',[Active Cases]))
return
IF(
    HASONEFILTER('Cases'[Team Name]),
    [Case Length (Adj)],
SUMX(
    _table,[Value1]))

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago

Thanks for this, unfortunately it doesn't work because Case Length [Adj] is a Calculated Column within the Cases table.

Instead, Is it possible to SUM all the non-working days in my Date2 table and subtract this total from the Case Length Average for each Team?

 

Thanks