Forum Discussion

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
3 years ago
Solved

Fixed Denominator Calculation that Includes Filter

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?
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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]))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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]))

  • heidibb's avatar
    heidibb
    Icon for Helper IV rankHelper IV
    3 years ago

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