Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
If I change the first measure to be like the second measure I get the exact same result.
So my question is if somebody could explain any reason for having the CROSSFILTER and ALL in the first measure.
First Measure
------------
var datum = CALCULATE(max(Dim_Calendar_ArrivalDate[Date]),
CROSSFILTER(Dim_Calendar_ArrivalDate[Dim_Calendar_SK],HistoryFact_Booking[Dim_CalendarArrivalDate_SK], None))
var caltable= CALCULATETABLE(Blocked_Units, Blocked_Units[date] = datum, ALL(Dim_Calendar_ArrivalDate[Date]) )
var sumxcal = SUMX(caltable, Blocked_Units[AntalUnitsBlockade])
sumxcal return
Second measure
--------------
var datum = CALCULATE(max(Dim_Calendar_ArrivalDate[Date]))
var caltable= CALCULATETABLE(Blocked_Units, Blocked_Units[date] = datum)
var sumxcal = SUMX(caltable, Blocked_Units[AntalUnitsBlockade])
sumxcal return
Many thanks in advance
Tony Johansson
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |