The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I need help getting a distinct count in a date range. My end goal is to get the count of Total_Clients and the distinct count for Total_Individual_Clients for Fiscal_Quarter 1 and 2 only.
As per the table below, I need the numbers to show Q1 as:
Client_ID Count = 6
Total_Individual_Cleints = 4
and Q2
Client_ID Count = 8
Total_Individual_Cleints = 4
My DAX for the Fiscal Quarter column:
If I put the Fiscal_Q in the X axis of a graph and the 2024_Q1_Q2_Client_Count in the Y Axis, it's exactly what I need.
I'm having trouble getting the distinct count of the Client_ID within the same date parameters only showing Q1 and Q2. How can this be achieved, please?
Client_ID | Date | Fiscal_Quarter |
1111 | 01/04/2024 | Q1 |
2222 | 01/04/2024 | Q1 |
3333 | 01/05/2024 | Q1 |
1111 | 01/05/2024 | Q1 |
4444 | 01/06/2024 | Q1 |
4444 | 01/06/2024 | Q1 |
8888 | 01/07/2024 | Q2 |
3333 | 01/07/2024 | Q2 |
3333 | 01/07/2024 | Q2 |
2222 | 01/08/2024 | Q2 |
3333 | 01/08/2024 | Q2 |
4444 | 01/08/2024 | Q2 |
4444 | 01/08/2024 | Q2 |
2222 | 30/09/2024 | Q2 |
4444 | 01/10/2024 | Q3 |
5555 | 01/10/2024 | Q3 |
2222 | 01/10/2024 | Q3 |
Thanks for your help!
Solved! Go to Solution.
Use DISTINCTCOUNT instead of COUNT for Total_Individual_Clients.
Proud to be a Super User!
Use DISTINCTCOUNT instead of COUNT for Total_Individual_Clients.
Proud to be a Super User!
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |