Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi. I need help vith creating a dinamic total calculations in my calendar table.
So I have a table called Dataset consisted of foloving columns: ArchDate, Type, Status.
And of caurse I can use slicers to filter it by Status or Type.
Ive created a Calendar table using DAX
MyCalendar = CALENDAR(DATE(2020,01,01),TODAY())
Then I've added calculated column "Totals" which counts a number of occurances of each date in Dataset[ArchDate]
Totals =
var total_Calc=CALCULATE(COUNTA('Dataset'[ArchDate]),FILTER('Dataset','Dataset'[ArchDate]=MyCalendar[Date]))
return if(total_Calc=BLANK(),0,total_Calc)
And now my calendar looks like this
But my problem is that I cant use slicers to filter values of Dataset. For example I need to count just First Stage but if I select the value of the Typeslider values of MyCalendar[Totals] remains the same.
Please advise how to resolve it. Is it possible? This is my sample pbix https://file.io/Hk0hc48YCOfi
@Riggan2023 , Create a measure like
Totals =
var total_Calc=CALCULATE(COUNTA('Dataset'[ArchDate]),FILTER('Dataset','Dataset'[ArchDate]=related(MyCalendar[Date]))
return if(total_Calc=BLANK(),0,total_Calc)
I think this should work too
Totals = CALCULATE(COUNTA('Dataset'[ArchDate]))+0
I've tried both your suggestions:
Totals =
var total_Calc=CALCULATE(COUNTA('Dataset'[ArchDate]),FILTER('Dataset','Dataset'[ArchDate]=related(MyCalendar[Date])))
return if(total_Calc=BLANK(),0,total_Calc)This shows me that MyCalendar[Date] does not exists.
The second code counts same totals for each row
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 101 | |
| 76 | |
| 56 | |
| 51 | |
| 46 |