Max No. per Week

[AllanBerces]

Hi good day,

Can pls someone help me on my measure. I have table i want to get the max no. of pax per week

My Table:

Output using measure

Thank you

[danextian]

Hi @AllanBerces ,

--returns the max per week regardless of other columns in the visual 
CALCULATE ( MAX ( 'table'[pax] ), ALLEXCEPT ( 'table', 'table'[Week No.] ) )

--returns the max per week per trade per area 
CALCULATE (
    MAX ( 'table'[pax] ),
    ALLEXCEPT ( 'table', 'table'[Week No.], 'table'[trade], 'table'[area] )
)

[rajendraongole1 · Accepted solution]

Hi @AllanBerces - calculate the maximum number of Pax per week for each Trade , you can create below measure

please replace with your table name as per your model.

MaxPaxPerTrade1 =

SUMX(

    SUMMARIZE(

        'Trad',

        'Trad'[Trade],

        'Trad'[WeekNo.],

        "MaxPax", MAX('Trad'[Pax])

    ),

    [MaxPax]

)

output:

Hope it helps.

[AllanBerces]

Hi @rajendraongole1 @danextian thank you for the reply for the solutions on my query.