Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
Solved! Go to 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.
That worked! Thank you!
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.