Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to understand the difference between the two measures below. I thought they will generate the same results, except option1 filters calendar[Date] through filter() function while option 2 filter calendar[Date] via datesbetween().
However, these two measures generate different results. It looks filter() always take current filter context (year-month) as a default context and apply conditions on top of it. Datesbetween () take the whole calendar[Date] as the starting point, ignoring date context in the matrix table context.
Is that normal that datesbetween behaves this way? I have never heard of a function (except "all()", "allexcept()") that would ignore current filtering context automatically.
option1
Solved! Go to Solution.
@Anonymous , time intelligence function is used outside filter function has a different impact than the one you have used in filter
refer if this can help
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
@Anonymous , time intelligence function is used outside filter function has a different impact than the one you have used in filter
refer if this can help
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |