Forum Discussion
Table Total Incorrect with Measure A using in New Measure
Hi,
I have loaded data into power BI from excel and I have created relationship betweeen tables using currency column.
Sheet 1
Sheet 2
Now I have following measures
But when I use this measure I have incorrect total values for measure "Net price" as below (I have checked the formats of each column to be in decimal format)
Any suggestions to solve this ?!
Thanks in advance
Ashish_Mathur (May be can you help me regarding this post!)
Hi,
PBI file attached.
Hope this helps.
19 Replies
The8 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8Greg_Deckler I have already gone through your post and videos but I coudn't able to solve the problem. I coudn't able to get your solution methodology exactly in my scenario.
That would be great if have a solution exactly according to my data.
Thanks !!The8 Cool, please post your data as text and all relevant formulas.
Hi,
Share the download link of the PBI file with your measures already written. Show the problem and the expected result.
Hello Ashish_Mathur ,
FYI, In the loop of this topic, you can see I already had conversation with other community members but I coudn't able to solve the problem.
Sheet 1:Material Date Quantity Price Currency X1 01.01.2024 30 86 EUR X2 01.01.2024 20 177 USD X3 01.01.2024 15 36 EUR X1 01.02.2024 43 81 EUR X2 01.02.2024 46 165 USD X3 01.02.2024 34 40 EUR X1 01.03.2024 28 85 EUR X2 01.03.2024 46 175 USD X3 01.03.2024 32 35 EUR
Sheet 2 :From € to $ (Conv. Rate) Currency 1,08 USD 1 EUR
Both this tables are in relationship by column Currency.Measures:
Final Price in € = DIVIDE(SUM(Sheet1[Price]),SUM('Sheet2'[From € to $ (Conv. Rate)]),0)Net price = DIVIDE([Final Price in €],SUM(Sheet1[Quantity]),0)
Thanks !!That does not give me what i requested for in my previuos message.
