Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
115 | |
74 | |
57 | |
47 | |
39 |
User | Count |
---|---|
167 | |
118 | |
61 | |
58 | |
50 |