Cálculo de Régua

[renanpinheiro]

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?

[v-ljerr-msft]

Hi @renanpinheiro,

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

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

Regards

[renanpinheiro]

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 · Accepted solution]

Hi @renanpinheiro,

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

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