Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!