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

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

3 Replies

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