Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Need Help to fix the total value for 30 rolling days and 90 rolling days issue (Input date from Date slicer)
Formula :
Totallogin = var t=SUMMARIZE('userloggedinacc','userloggedinacc'[CountryCode],"UserDistinct",DISTINCTCOUNT(userloggedinacc[UserID] ))return SUMX(t,[UserDistinct])
30-Days Rolling = CALCULATE([Totallogin],DATESINPERIOD(dimdate[CalendarDate],MAX(userloggedinacc[LoggedInOn]),-30,DAY))
90-Days Rolling = CALCULATE([Totallogin],DATESINPERIOD(dimdate[CalendarDate],MAX(userloggedinacc[LoggedInOn]),-90,DAY))
I will appriciate any advice how to accomplish that.
Guys,
Thank you so much for your support, Have modified the below Dax formula
and it is working as expected both Matrix and cluster columnchart.
Formula :
Totallogin = var t=SUMMARIZE('userloggedinacc','userloggedinacc'[CountryCode],"UserDistinct",DISTINCTCOUNT(userloggedinacc[UserID] ))return SUMX(t,[UserDistinct])
30-Days Rolling = CALCULATE([Totallogin],
Filter (ALL(dimdate),
dimdate[CalendarDate] > MAX(dimdate[CalendarDate])-30 &&
dimdate[CalendarDate] <= MAX(dimdate[CalendarDate])
))
90-Days Rolling = CALCULATE([Totallogin],
Filter (ALL(dimdate),
dimdate[CalendarDate] > MAX(dimdate[CalendarDate])-90 &&
dimdate[CalendarDate] <= MAX(dimdate[CalendarDate])
))
Did you check relationship between the tables.
Hi Aditya,
Yes relationship is there with bussinesskey
okay, try to enble cross filter(Both), bcoz the dax you wrote is perfectly okay(jst check summerize dax again).
Hello Team,
Is someone able to help to fix this DAX Formula?
Thank you inadvance
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |