Max and min value

[sujaypr3]

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]),[Revenue])

It is perfectly calculating.  The problem is, if I have selected 2 years and their respective quarters say Q1 to Q4 for FY22 and Q1 to Q4 for FY23, I get max and min value for each year separately.  I want to know which is max and min across 8 quarters that is displayed in visuals

[AlexisOlson · Accepted solution]

Try adding Calendar[Year] to the measure.

MAXRev = MAXX(ALLSELECTED(Calendar, Calendar[Year], Calendar[Quarter]), [Revenue])

[sujaypr3]

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]

OK. 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]
)