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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Fadwa
Frequent Visitor

Goal seek function

Hi

 

I've seen one of the cases that been solved https://community.powerbi.com/t5/Desktop/HELP-WITH-DAX-Simulate-Excel-What-If-Analysis-Goal-Seek/m-p...

 

which is too similar to something I've been struggling with I will use the same letter he used, the difference is that I want my goal always to be zero:

 

( A * x ) - ( B * x ) = 0  

 

How its gonna work?

I really appreciate your efforts, It will mean a lot if you know the solution!  

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

Not sure the Algebra works on that one.

(A * x) - (B * x) = 0
x * (A - B) = 0
x = 0 / (A - B)
x = 0

So, x = 0


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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