Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ganesh1984
Frequent Visitor

Dax Puzzle

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? 

 

Puzzle1.PNG

 

1 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.
Capture.PNG
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

4 REPLIES 4
manikumar34
Solution Sage
Solution Sage

@Ganesh1984 , that's wierd. 

 

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

manikumar34_0-1601374701515.png

 

 

Regards, 

Manikumar

 





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@Ganesh1984 ,

Try this DAX column:

Puzzle = CALCULATE(MIN('Car Master'[Price]),ALL('Car Master'))
 
Capture.PNG
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

@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.
Capture.PNG
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@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])

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.