Forum Discussion
joshcomputer1
Helper V
Helper VMeasure not being sliced by filter
I have a key named "teams" that has one column of team names. It has a one to many relationship with table masterall[team]. I used the teams table as the field in the slicer. When I try to slic...
The likely problem is your ALL clause. You probably want to switch to ALLEXCEPT and include your Teams in your ALLEXCEPT.
Greg_Deckler
Community Champion
Community ChampionThe likely problem is your ALL clause. You probably want to switch to ALLEXCEPT and include your Teams in your ALLEXCEPT.
joshcomputer1Worked like a charm!
Count of Active Employee =
VAR endOfPeriod =MAX ( 'DateTable1'[Date] )
VAR startOfPeriod = MIN( 'DateTable1'[Date] )
RETURN
CALCULATE (
COUNTROWS ( MasterAll ),
FILTER (
ALLexcept(MasterAll, 'Key Teams'[Teams]),
MasterAll[Start Date] <= endOfPeriod
&& MasterAll[End Date] >= startOfPeriod
&& masterall[title]<>"non-billable"
&& masterall[title]<>"bench")
)