Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Regards,
Solved! Go to 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
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
Hi Tom,
Thank you for the reply.. I am expecting one more condition in this dax like removing zero values also
Thanks,
Krithika
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |