Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.