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!
Go to Solution.
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
@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
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.