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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dcardin
New Member

Moving from Tableau to PowerBI - Beginner!

Hi everyone.

I have been using Tableau with their relationships and expressions for a while now and I am having a hard time adapting to DAX, not for a lack of trying.

 

My model is composed of 2 tables:

 

Quotes: QuoteID, LineID, Quantity, Price

Options: LineID, name, value

 

Quotes is linked to options on the LineID, one to many

 

 

What I would like to do is calculate the total price of quotes, for different selections of options.

 

I have started with a calculated column  [Quantity] * [Price], but when it's aggregated in any way, the numbers are completely off.

I have tried with CALCULATE trying to fix it at the LineID but to no avail.

 

what is the proper DAX expression that will allow me to get the total price while functioning in a Matrix with multiple filters/dimension?


Thanks in advance!

 

1 ACCEPTED SOLUTION
dcardin
New Member

Hello @TheoC 

My problem was not related to my DAX formulas, but simply to the model, the filtering must be bi-directionnal, and it was set as one direction only. 

 

Thanks for trying to help, it's appreciated.

View solution in original post

3 REPLIES 3
dcardin
New Member

Hello @TheoC 

My problem was not related to my DAX formulas, but simply to the model, the filtering must be bi-directionnal, and it was set as one direction only. 

 

Thanks for trying to help, it's appreciated.

@dcardin good to hear it is sorted! All the best.

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

TheoC
Super User
Super User

Hi @dcardin 

 

Are you able to provide some sample data or some screenshots?   Ideally, it would be good to get a view of what you are getting as an output versus what you are expecting / wanting the output to be.

 

Thanks heaps.

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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