Fixed Denominator Calculation that Includes Filter

[heidibb]

Hello!

I have a measure: 

Denominator = CALCULATE(DISTINCTCOUNT(Combined[User Story ID]), filter('Stories - Today','Stories - Today'[ReportStatusRank] <> 99))

I would like this number to react to a single slicer only (Epic), but stay fixed otherwise. 

I know this is likely something to do with ALL, ALLSELECTED or ALLEXCEPT, but these thoroughly confuse me.

Thoughts?

[heidibb]

Thank you! That second option was the winner. I knew the correct components, but not how to structure them properly. Thank you so much!

[amitchandak · Accepted solution]

@heidibb , Try like

Denominator = CALCULATE(DISTINCTCOUNT(Combined[User Story ID]), filter('Stories - Today','Stories - Today'[ReportStatusRank] <> 99), allexpect('Stories - Today', 'Stories - Today'[Epic]))

or

Denominator = CALCULATE(CALCULATE(DISTINCTCOUNT(Combined[User Story ID]), filter('Stories - Today','Stories - Today'[ReportStatusRank] <> 99)), allexpect('Stories - Today', 'Stories - Today'[Epic]))