Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Adding up total workdays from a date filter

Hello,   I am trying to make a measure that would dynamically add up all of the values in my work day column using a date filters max and min values that I put into my report: Let say we hav...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

How did you do it for now? This could be simple like below.

 

measure =
SUM ( 'DateTable'[IsWorkday] )

If you'd like to ignore the slicer, try this one.

 

 

measure =
CALCULATE (
    SUM ( 'DateTable'[IsWorkday] ),
    ALL ( 'DateTable'[cw_Dateofservice] )
)

 

Best Regards,
Dale