Is it possible to have a dimension that is either True or False and if you filter with it it only removes one measure from the fact.
1 5 1
1 10 0
1 12 0
No Filter: Sum(hours)=27, Count(ActivityCount)=3
Filter out where Filter=1: Sum(hours)=22, Count(ActivityCount)=2
But what I want is when Filter=1 is that only the hours get reduced to 22 but the Count(ActivityCount) stays equal to 3. Meaning, I want to filter out one measure but not all.
View Complete Post