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.
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!