Forum Discussion
Solved
Max and min value
Hello, I have created fax to find max and min value as follows: MAXRev = MAXX(ALLSELECTED(Calendar, Calendar [Quarter]),[Revenue]) MINREev =MINX(ALLSELECTED(Calendar, Calendar [Quarter]),...
Try adding Calendar[Year] to the measure.
MAXRev = MAXX(ALLSELECTED(Calendar, Calendar[Year], Calendar[Quarter]), [Revenue])
I have already tried this. But the result is same where I get max and min for per fiscal year.
note, I have mentioned quarter sorry by Year to get correct grouping in visual
AlexisOlson
Super User
Super UserOK. There may be some other calendar column interfering. Try doing ALLSELECTED on the entire table. I'm not sure exactly what columns you have but try something like this:
MAXRev =
MAXX (
SUMMARIZE (
ALLSELECTED ( Calendar ),
Calendar[Year],
Calendar[Quarter]
),
[Revenue]
)