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

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

Hi Jo5hua22, are we missing a piece of the puzzle as it looks like you could just use MAX aggregation on the Qty column?:

MAX(Qty)

 

Jo5hua22's avatar
Jo5hua22
Helper I
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]))