Create a table with group by of min value doesn't contain zero's using dax

[KrithikaBaskar]

Hi,

   Need to create a table from existing table by group by function with min value doesn't include zero on that. I have use the below dax for that

Min value =

GROUPBY('Table'[Country],

'Table'[colour],

'Table'[category],

"Min Price",

MINX(CURRENTGROUP(),MIN('Table'[Price per kg])))

I doesn't want to create using Mquery.. I am trying in dax, creating a new table

Regards,

[TomMartens]

Hey @KrithikaBaskar 

use this DAX statement to create the table:

Min Table = 
ADDCOLUMNS(
    SUMMARIZE(
        'Table'
        , 'Table'[Country]
        , 'Table'[Category]
        , 'Table'[Colour]
    )
    , "Min Price", CALCULATE( MIN( 'Table'[Price per kg] ) )
)

This is how my base table looks:

And this is how the table looks like that is created from the above DAX statement:

Hopefully, this is providing what you are looking for.

Regards,

Tom

[KrithikaBaskar]

Hi Tom,

    Thank you for the reply.. I am expecting one more condition in this dax like removing zero values also

Thanks,

Krithika

[TomMartens · Accepted solution]

Hey @KrithikaBaskar ,

this DAX statements creates a table without zeros

Min Table = 
FILTER(
    ADDCOLUMNS(
        SUMMARIZE(
            'Table'
            , 'Table'[Country]
            , 'Table'[Category]
            , 'Table'[Colour]
        )
        , "Min Price", CALCULATE( MIN( 'Table'[Price per kg] ) )
    )
    , [Min Price] <> 0
)

Hopefully, this is what you are looking for. If not provide sample data and the expected result.

Regards,

Tom

[KrithikaBaskar]

Thank You @TomMartens