Forum Discussion
Filter function not working with MAX function
Hi Anonymous ,
Measure works on visual level. In the first measure, you used filter(table), so the max() function wouldn't give you the max value for all table but only the max value for the row. You can create a single measure like maxvalue = max(table[column]) to check.
In that case you may use ALLSELECTED() or ALL() function like below.
In addition, It's better to share some sample data to us so that we can deal with the DAX for you.
Best Regards,
Jay
Hi Anonymous ,
Measure works on visual level. In the first measure, you used filter(table), so the max() function wouldn't give you the max value for all table but only the max value for the row. You can create a single measure like maxvalue = max(table[column]) to check.
In that case you may use ALLSELECTED() or ALL() function like below.
In addition, It's better to share some sample data to us so that we can deal with the DAX for you.
Best Regards,
Jay