Forum Discussion

telesforo1969's avatar
telesforo1969
Icon for Helper V rankHelper V
3 years ago

Count how many maximums are?

It might be something very easy but I just don't know how to code. I want to calculate how many maxima there are per row.
I have the Measure to calculate the maximum value per row
= CALCULATE(MAXX(VALUES(TableSumConcept),TableSumConcept[sumConcept]))

but i need support to count how many max is per row (H)

 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    telesforo1969 , Assume you are using measure, M1; code to replace subtotal with max

     

    if( not(isinscope(Date[Year])) ,  MAxx(values(Table[id]), [M1]), [M1])

     

    if not subtotal

    if( not(isinscope(Date[Year])) ,  calculate(MAxx(values(Table[id]),  [M1]) , removefilters(Date[Year]) ), [M1])

    • telesforo1969's avatar
      telesforo1969
      Icon for Helper V rankHelper V
      3 years ago

      Thank you so much. I have implemented your formulas you can see it in the image.

       

       

      I would appreciate your support to generate a measure to calculate how many times the maximum is repeated by ID.

       

      The Maximo Measures:

      Máximo = CALCULATE(MAXX(VALUES(DATOS), DATOS[Valor]))
       
      Maximo1 = IF(NOT(ISINSCOPE(DATOS[Año])),MAXX(VALUES(DATOS[ID]),[Máximo]),[Máximo])
       
      Maximo2 = IF(NOT(ISINSCOPE(DATOS[Año])),CALCULATE(MAXX(VALUES(DATOS[ID]),[Maximo1]),REMOVEFILTERS(DATOS[Año])),[Maximo1])
       
      Maximo3 = IF(NOT(ISINSCOPE(DATOS[Año])),CALCULATE(MAXX(VALUES(DATOS[ID]),[Máximo]),REMOVEFILTERS(DATOS[Año])),[Máximo])