Problem getting minomo value by group

[victormarconis]

Hello, I have a table (table1) created by DAX, it returns the products and their last input value. I tried to create a calculated column to find the lowest value per group (presentation). So, in theory, this column (column 1) is returning me correctly, but there are some products that it returns the lowest value of a product that has no presentation, the big problem is just that.
Below is the table and column used.

PS: I already tried using measures or a new calculated table.

Table 1:

UltimasEntradas =

    SUMMARIZE(

        FILTER(Entradas, entradas[data_hora] >= TODAY() - 180 && entradas[data_hora] <= TODAY()),

        Entradas[produto_id],

        "NomeProduto", MAX(entradas[produtoid]),

        "UltimaData", MAX(entradas[data_hora]),

        "UltimoValor", LASTNONBLANK(entradas[Valorsemimposto], 1)

    )


Column 1:

Min_Produto =

VAR MinValue =

    CALCULATE(

        MINX(UltimasEntradas, UltimasEntradas[UltimoValor]),

        ALLEXCEPT(UltimasEntradas, 'apresentaçao'[apresentacao])

    )

RETURN

    MINX(

        FILTER(UltimasEntradas, UltimasEntradas[UltimoValor] = MinValue),

        UltimasEntradas[NomeProduto]

    )


Subtitle:

apresentacao = group

ultimovalor = lastvalue
nomeproduto = nameproduct

[technolog]

You have a table, UltimasEntradas, which is a summary of another table, Entradas, and it's filtered for entries within the last 180 days. This table gives you the product ID, product name, the last date of entry, and the last value without tax for each product.

You're trying to get the minimum value (ultimovalor) for each group (apresentacao). The problem you're facing is that for some products, the minimum value returned is from a product that doesn't belong to any presentation group.

The DAX for Column 1 you provided is trying to get the minimum value for each group and then return the product name (nomeproduto) that has this minimum value.

From what I understand, the issue is that the minimum value is sometimes taken from a product that doesn't belong to any presentation group. To fix this, you should filter out those products without a presentation before calculating the minimum value.

Here's a suggestion to modify your Column 1:

Min_Produto =
VAR MinValue =
CALCULATE(
MINX(UltimasEntradas, UltimasEntradas[UltimoValor]),
ALLEXCEPT(UltimasEntradas, 'apresentaçao'[apresentacao]),
NOT(ISBLANK(UltimasEntradas['apresentaçao'[apresentacao]])) -- This line ensures we only consider products with a presentation
)

RETURN
MINX(
FILTER(UltimasEntradas, UltimasEntradas[UltimoValor] = MinValue),
UltimasEntradas[NomeProduto]
)
The added line ensures that when calculating the minimum value, it only considers products that have a presentation. This should prevent the issue where the minimum value is taken from a product without a presentation.