Forum Discussion

sujaypr3's avatar
sujaypr3
New Member
2 years ago
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]),...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    Try adding Calendar[Year] to the measure.

    MAXRev = MAXX(ALLSELECTED(Calendar, Calendar[Year], Calendar[Quarter]), [Revenue])
AlexisOlson's avatar
AlexisOlson
Super User
2 years ago

Try adding Calendar[Year] to the measure.

MAXRev = MAXX(ALLSELECTED(Calendar, Calendar[Year], Calendar[Quarter]), [Revenue])
sujaypr3's avatar
sujaypr3
New Member
2 years ago

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's avatar
    AlexisOlson
    Super User
    2 years ago

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