Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |