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 am using the Dax to get Monthly Distinctcount of IDs. Need Quaterly result where Quarter is selected it should give the sum of each month result derived from Dax meassure. When I directly giving as quarter it is taking Distinctcount of IDs of entire quarter.
expected Quarter result as 3+3+2=8 , but when I try getting the result as 3
Jan-3
Feb-3
Mar-2
IDs Month
A1 Jan
A2 Jan
A2 Jan
A3 Jan
A1 Feb
A1 Feb
A3 Feb
A2 Feb
A2 Mar
A2 Mar
A1 Mar
Appreciate your kind help.Thanks!
Regards,
Naseef
Solved! Go to Solution.
@Anonymous
you can try this
Measure =
var TBL=SUMMARIZE('Table','Table'[Month],"count",DISTINCTCOUNT('Table'[IDs]))
RETURN sumx(TBL,[count])
Proud to be a Super User!
@Anonymous
you can try this
Measure =
var TBL=SUMMARIZE('Table','Table'[Month],"count",DISTINCTCOUNT('Table'[IDs]))
RETURN sumx(TBL,[count])
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
74 | |
63 | |
51 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |