Forum Discussion

renanpinheiro's avatar
renanpinheiro
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Cálculo de Régua

Hi guys,
I need to create a calculated column in the table below:

 

I have the "Cupons" and "Quantidade" columns. The "Items por Cupom" column is the division from the first to the second.
I need now to create a column in which I have the maximum value of the "Items por Cupom" column of each cluster (first column). In the image, it would be 0.65 for cluster 2, 0.61 for cluster 3, and so on. The values must be repeated row by row for each cluster.

 

Can someone help me?

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi renanpinheiro,

     

    Based on my test, the formula below should work in this scenario. :smileyhappy:

    Max of Items por Cupom =
CALCULATE (
    MAXX (
        SUMMARIZE (
            'BD_LACUNA',
            'BD_LACUNA'[Cluster],
            'BD_LACUNA'[NOME_LOJA],
            "Cluster_NOME_LOJA_Items", [Items por Cupom]
        ),
        [Cluster_NOME_LOJA_Items]
    ),
    ALLEXCEPT ( 'BD_LACUNA', 'BD_LACUNA'[Cluster] )
)

     

    Regards

3 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi renanpinheiro,

     

    Could you try the formula below to see if it works in your scenario? :smileyhappy:

    Max of Items por Cupom =
CALCULATE (
    MAX ( 'BD_LACUNA[Items por Cupom]' ),
    ALLEXCEPT ( 'BD_LACUNA', 'BD_LACUNA'[Cluster] )
)

     

    Regards

    • renanpinheiro's avatar
      renanpinheiro
      Icon for Advocate II rankAdvocate II
      9 years ago

      Hi v-ljerr-msft,

      The "Items por Cupom" column is a measure and the MAX function does not allow you to use measures, how can I get around this?

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi renanpinheiro,

         

        Based on my test, the formula below should work in this scenario. :smileyhappy:

        Max of Items por Cupom =
CALCULATE (
    MAXX (
        SUMMARIZE (
            'BD_LACUNA',
            'BD_LACUNA'[Cluster],
            'BD_LACUNA'[NOME_LOJA],
            "Cluster_NOME_LOJA_Items", [Items por Cupom]
        ),
        [Cluster_NOME_LOJA_Items]
    ),
    ALLEXCEPT ( 'BD_LACUNA', 'BD_LACUNA'[Cluster] )
)

         

        Regards