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:
Fiscal Q = "Q" & QUARTER(EDATE('Sheet1'[Date], -3))
Measure for Q1 and Q2 date range:
2024_Q1_Q2_Client_Count =
CALCULATE(
COUNT('Sheet1'[Client ID]),
'Sheet1'[Date]>=DATE(2024,4,1),
'Sheet1'[Date]<=DATE(2024,9,30)
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!
