Forum Discussion
How to recalulate two measures
I created a dedicated major table and divided the sales by the sales unit price, and while the results for each product are correct, the total is not displayed correctly.
So, I would like to use sum or calculate dax but they are need to table coulmun.
Coule you tell me how ot resolve it?
Thanks.
9 Replies
- suparnababu8
Super User
Hello Anonymous
Could you please share some snapshots of your output? While sharing the snapshots don't include sensitive data.
Thanks!
Thank you for reply.
Attachhed the snapshot I prepared.
Unit should be 6.51.(Total between M001 and M003).
I calculated the unit using the formula: divide(Sales after allcoation, Sale price from master) in measure.
All column are caluclated by measure. I could not use sum or caclulate dax becasue this table does not contain table data.
Do you have any good solutions?
Attached the snapshot I prepared.
Unit should be 6.51.(Total between M001 and M003).
I calculated the unit using the formula: divide(Sales after allocation, Sale price from master) in measure.
All columns are calculated by measure. I could not use sum or calculate Dax because this table does not contain table data.
Do you have any good solutions?
Hi Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
Unit = DIVIDE([Sales after allcoation],[Sale price from master])(2) We can create a new measure.
Measure = SUMX(VALUES('Table'[Material ID]),[Unit])(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Can you please share more details to help us clarify your scenario?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Neeko Tang
Anonymous
Thank you for reply.
I tried to uplaoed the PBI file, but I could not it so I explained details.
Unit is calculated by
Measure table contains only measures.
Sales after allocation from
Sales price from master from
The Sales Price Master is a master list of sales prices for each product, but since it is a table, I averaged it to use with DAX. I suspect this averaging might be the cause.
I'm happy if they are helpful to you.
Thanks.
Hi Anonymous ,
What do you place on the form visual object? Is your Material ID not a column? If so, you only need to place the Material ID field and the measure Measure on the visual object.
Measure = SUMX(VALUES('Table'[Material ID]),[Unit])Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
