Forum Discussion

Jo5hua22's avatar
Jo5hua22
Icon for Helper I rankHelper 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
Icon for Resolver II rankResolver 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)

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Russell-PBI Actually many pieces were missing but Jo5hua22 clearified all to me before he eventually found the solution by himself. I think there is another post by him of the same. 

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