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!View all the Fabric Data Days sessions on demand. View schedule
I use below dax code to calculate % of client survyes to the total survey count received.
| date slicer | ||||||
| 01-07-2022 | 31-Jan-23 | client | total surveys | total count | % contribution | |
| a | 45 | 2000 | 2% | |||
| b | 30 | 2000 | 2% | |||
| c | 14 | 2000 | 1% | |||
| d | 3 | 2000 | 0% | |||
| … | 56 | 2000 | 3% | |||
| 98 | 2000 | 5% | ||||
| total | 2000 | 100% |
this is not correct
| date slicer | total surveys | % contribution | ||||||
| 01-07-2022 | 31-Jan-23 | client | Jul-22 | total count | % | Jul-22 | total count | % |
| a | 45 | 1200 | 4% | 34 | 1200 | 3% | ||
| b | 30 | 1200 | 3% | 67 | 1200 | 6% | ||
| c | 14 | 1200 | 1% | 23 | 1200 | 2% | ||
| d | 3 | 1200 | 0% | 37 | 1200 | 3% | ||
| … | 56 | 1200 | 5% | 44 | 1200 | 4% | ||
| 98 | 1200 | 8% | 39 | 1200 | 3% | |||
| total | 1200 |
@prady2581 , In that case you should use remove filters of client
Client_count_All =
CALCULATE(
COUNT('Raw data'[clientname]),removefilters('Raw data'[client] )
)
Learn Power BI: All, allselected, removefilters,allexcept- https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!