Forum Discussion

Jo5hua22's avatar
Jo5hua22
Helper I
4 years ago
Solved

Max value based on filter

Hi Users   Can you please help me with finding the maximum value based on filters?   Steps to be done: 1. Filter Measurement Type as Trial 1. 2. Filter Machine as 1011 3. In the quantity, you ...
Help me please
  • Jo5hua22's avatar
    Jo5hua22
    4 years ago

    Hi all

    Thanks for your comments. I managed to find a solution for my problem

    In a measure variable,

    #Meas =
    CALCULATE(
    MAXX(
    SUMMARIZE(Table1,Table1[Measurement Type],Table1[Machine],"Count",COUNT(Table1[Qty]))
    ,[Count]
    ),ALLEXCEPT(Table1,Table1[Measurement Type],Table1[Machine]))

Jo5hua22's avatar
Jo5hua22
Helper I
4 years ago

Hi Russell-PBI 

I need to apply filters as mentioned in the steps. Max(QTY) just shows the maximum value in the table

  • Russell-PBI's avatar
    Russell-PBI
    Resolver II
    4 years ago

    Do you mean you want a measure that itself is filtered, like this?:

    Max Qty - 1011 and Trial 1 = 
    CALCULATE(
    MAX('Table'[Qty])
    , 'Table'[Machine] = 1011
    , 'Table'[Measurement Type] = "Trial 1"
    )