Measure counting total rows that is same fixed number for each category but changes when filtering

[silja123]

Hi all,

I have a problem that I can't figure out for some reason...

I have created table like this from my original multiple choise investigation data:

Multiple choice options          SumOfAnswers         CountOfAnswerers
A                                             10                             10
B                                              20                             20
C                                              50                             50
D                                              40                            40
Total                                        120                           50

SumOfAnswers is the sum of "yes" answers and answeres were able to answer "yes" to many options (not only one). So 50 people answered (Total od CountOfAswers) but they might have said yes to many options.

Now I want to create a measure seen in the table below (TOTALCountOfAnswers) BUT so that when I filter spesific group of answeres (for example women) the TOTALCountOfAnswerers changes from all 50 to 30 (number of women respondents): 

Multiple choice options          SumOfAnswers         CountOfAnswerers            TOTALCountOfAnswerers
A                                             10                             10                                        50
B                                              20                             20                                       50
C                                              50                             50                                       50
D                                              40                            40                                       50
Total                                        120                           50                                       50
                   
Because in the end I want to get the persentage of answers in relation to the respondent group (men/woman, age group etc.). So the divider should change based on the filter/respondent group but the TOTALCountOfAnswerers should not be divided between categories (A, B, C, D) as in CountOfAnwers. In the visual/diagram, however, the bars are formed by categories (A, B, C, D). The "All" function does not work as it then doesn't change the number based on my filtering. I have also tried "allexcept" funtion to exclude the "Multiple choice options" categories but that does not work either...

I would be super happy and grateful for help, thanks!

[v-luwang-msft]

Hi @silja123 ,

Pls test :

Calculate(Countrows(Table), ALLSELECTED(Table))

refer:

https://learn.microsoft.com/en-us/dax/allselected-function-dax 

Best Regards

Lucien

[katika555]

Calculate(Countrows(Table), All(Table))

[silja123]

It does not work becaused then  TOTALCountOfAnswerers is always 50 and doesn't change when I filter different respondent groups, as I explained...