Forum Discussion

colem246's avatar
colem246
Frequent Visitor
8 years ago
Solved

Aggregating measure based on dates

Hello,   I have a count of employees working with the slicer on the date. I would like to get a culmative total of employees working based on days selected.   Ex. # Employees Working = DISTINCTC...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    colem246

     

    Try this MEASURE

     

    =
SUMX ( ALLSELECTED ( TableName[Dates] ), [# Employees Working] )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

colem246

 

Try this MEASURE

 

=
SUMX ( ALLSELECTED ( TableName[Dates] ), [# Employees Working] )