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. ...
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

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