Sum total of filtered categorical variables, SAMPLE SIZE

[allymn789]

Hi group!

I am working on a project that has about 12 different demographic categories (age, gender, etc.).  Each of the categories can be filtered singly or several of them to show the results of the study.  That part is working. 

There are 1300 responses to the survey but the end user won't know the sample size of the study results after they select their filters.  If they want to see the study results of 25-30 year olds who are female and are under 5'5" in height, that could be 1200 of the respondants or 50.  I am trying to set up another page on the dashboard so users can see the sample sizes associated with their selection criteria.  Is it possible to display a single number on a page that shows the total respondants after filtering?  I tried using the Q&A graphic but could only use one column, or criteria, at a time.  I didn't see a way to add other filters to that.

Thank you!

[jdbuchanan71 · Accepted solution]

You can write a measure that counts the unique respondents based on the applied filters, somthing like

Respondants = DISTINCTCOUNT ( YourTable[Respondend_ID] )

If you have slicers on your first page you can copy then to a second page, sync them with the ones on the first page so when a user makes a change to the silcers on the first page the same selections are made on the new page.  Then you can hide the slicers on the second page and add a card to the page with the repspondant measure from above.  

[allymn789 · Accepted solution]

That worked!  Thank you!

[jdbuchanan71 · Accepted solution]

You can write a measure that counts the unique respondents based on the applied filters, somthing like

Respondants = DISTINCTCOUNT ( YourTable[Respondend_ID] )

If you have slicers on your first page you can copy then to a second page, sync them with the ones on the first page so when a user makes a change to the silcers on the first page the same selections are made on the new page.  Then you can hide the slicers on the second page and add a card to the page with the repspondant measure from above.