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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
1. 'Table'[Total Amount] <----- Column from the model
2. Measure = SUM('Table'[Amount])
I have a column coming from the model (1) and then created a measure that takes the sum of the column (2), So when creating another Measure to apply a filter would there be a difference in performance between the 2 Measures Below?
Measure 1 = Calculate( [Measure], 'Table'[Date] = "04-12-2020" )
Measure 2 = Calculate( SUM('Table'[Total Amount]), 'Table'[Date] = "04-12-2020" )
Same Result from both measure just wondering if one is faster than the other or the same in performance?
Solved! Go to Solution.
no difference.
actually
Measure 1 = Calculate( [Measure], 'Table'[Date] = "04-12-2020" )
is this๏ผ
Measure 1 = Calculate( Calculate( SUM('Table'[Total Amount])), 'Table'[Date] = "04-12-2020" )
the two Calculates will be coumted as one
no difference.
actually
Measure 1 = Calculate( [Measure], 'Table'[Date] = "04-12-2020" )
is this๏ผ
Measure 1 = Calculate( Calculate( SUM('Table'[Total Amount])), 'Table'[Date] = "04-12-2020" )
the two Calculates will be coumted as one
Check out the November 2025 Fabric 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!