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.
@johnt75 has hinted at what the problem was. The two values are start and end values that are set by filters.
The Dax formulas are the same but the filters set different results. So the calculation is treating both as equal therefore returning 0. The solution is to use something like the below
Are there different filters being applied to the visuals showing the results ?
Try running the below in DAX Studio
EVALUATE
ROW (
"#AADP MAU_Start", [#AADP MAU_Start],
"#AADP MAU_End", [#AADP MAU_End],
"#AADP MAU Increase", [#AADP MAU Increase],
"Simple calc", [#AADP MAU_End] - [#AADP MAU_Start]
)
The start and end values come from filters. The Dax formulas are the same but the filters set different results
So it appears that is the issue then.
Do you have any idea how I may trick it into retaining the displayed filter results so that I can get the substraction to be valid?
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 |
---|---|
44 | |
20 | |
20 | |
16 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |