"isinscope"
1 Topic
Divide measure that excludes values without Calculate
Hi I wish to amend the following query to exlcude "No" from the numerator as well as the demoninator. However if I use CALCULATE to try and achieve this it loses the context and sets all values to 1 (or 100%) within my matrix. How do I exclude "No" from the numerator? % of Responses = IF( ISINSCOPE(Survey[Responses]), DIVIDE( COUNTA(Survey[Responses]), CALCULATE( COUNTA(Survey[Responses]), Survey[Responses] <> "No", REMOVEFILTERS(Survey[Responses]) ) ) )Solved1KViews0likes4Comments