Dax Puzzle

[Ganesh1984]

Why does the minimum price in the puzzle column of the Puzzle table indicate $5. Interestingly, if I replace $0 with $1 the answer will be $1. Is this a puzzle? 

[manikumar34]

@Ganesh1984 , that's wierd. 

I tried the same DAX interestingly I'm getting different answer. 

Regards, 

Manikumar

[Tahreem24]

@Ganesh1984 ,

Try this DAX column:

Puzzle = CALCULATE(MIN('Car Master'[Price]),ALL('Car Master'))

[Tahreem24 · Accepted solution]

@Ganesh1984 ,

And if you want to revamp your own mentioned DAX so just remove the Price column after ALLEXCEPT. Make it like below:

Puzzle = CALCULATE(MIN('Table'[Price]),ALLEXCEPT('Table','Table'[Food]))

So you'll get $0 in output.

[amitchandak]

@Ganesh1984 , You are creating a column

Try like for Min

minx(filter(puzzle, [food] =earlier([food]) ),[price])

For max

maxx(filter(puzzle, [food] =earlier([food]) ),[price])