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.
Ok, maybe I'm dumb, but what could be wrong with this measure? I'm trying to get the max value and ignore the time filter.
Max difference =
VAR table_x =
ADDCOLUMNS (
'Hourly calendar',
"input", [Input measure],
"output", [Output measure]
)
VAR max_difference =
CALCULATE ( MAXX ( table_x, [input] - [output] ), ALL ( 'Hourly calendar' ) )
RETURN
max_difference
Solved! Go to Solution.
Once you define a variable, it's fixed and will not be modified by CALCULATE adjusting filter context.
See if this works better:
Max difference =
VAR table_x =
ADDCOLUMNS (
ALL ( 'Hourly calendar' ),
"input", [Input measure],
"output", [Output measure]
)
VAR max_difference = MAXX ( table_x, [input] - [output] )
RETURN
max_difference
Once you define a variable, it's fixed and will not be modified by CALCULATE adjusting filter context.
See if this works better:
Max difference =
VAR table_x =
ADDCOLUMNS (
ALL ( 'Hourly calendar' ),
"input", [Input measure],
"output", [Output measure]
)
VAR max_difference = MAXX ( table_x, [input] - [output] )
RETURN
max_difference
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |