Forum Discussion
IF STATEMENT BASED ON MAX VALUE
Anonymous
"My Max" is a calculated column and you have set the calculation to MAX . If you can share a sample file then it would be great.
Hi @ Fowmy,
unfortunately due to data protection I am unable to share the data.
I have created a measure to get the max based on a calculated and then used the ALL EXCEPT filter however although I have used the MAX function when I add it to a table visual it doesn't show the max, instead I have the option to get the average, min,max,standard deviation etc. Once I select MAX though and it gives me the results I require. From this calculation I now need to sum the rows for 2 columns when the values for "My Max" has been set to MAX.
I have managed to resolve this myself, no further assistance required for this query.
- Fowmy
Super User
Anonymous
Gald you managed to solve it. Happy to assist you in any future issues/questions.