Forum Discussion

The8's avatar
The8
Helper II
2 years ago
Solved

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 Final Price...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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/n4TYhF2ARe8

  • The8's avatar
    The8
    Helper II
    2 years ago

    Greg_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 !!

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      2 years ago

      The8 Cool, please post your data as text and all relevant formulas.

      • The8's avatar
        The8
        Helper II
        2 years ago

        Hello Greg_Deckler ,

        Sheet 1

        MaterialDateQuantityPriceCurrency
        X101.01.20243086EUR
        X201.01.202420177USD
        X301.01.20241536EUR
        X101.02.20244381EUR
        X201.02.202446165USD
        X301.02.20243440EUR
        X101.03.20242885EUR
        X201.03.202446175USD
        X301.03.20243235EUR


        Sheet 2

        From € to $ (Conv. Rate)Currency
        1,08USD
        1EUR



        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 !!