Forum Discussion

KevBI's avatar
KevBI
Helper I
4 years ago

Need help with Measure

Hello PowerBI Professionals! I have 2 Measures that seem to work individually, but combined they somehow don't show the values they should. First Measure is:    _AmountInEUR = VAR __BASELI...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • KevBI's avatar
    KevBI
    Helper I
    4 years ago

    Okey sorry for the bad data.

    _AmountIn(€)SUM = SUMX(EKBE, [Amt.in loc.cur.]) / EKBE[_ExchangeRate]

    -This is what I did for the correct calculation but I still need the logic in the calculation that i left out on this one.

    Do you need any more data from me?
    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
      Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. Screenshots of your source data are not useful.
      Please show the expected outcome based on the sample data you provided