row calculations not correct

[Anno2019]

Hi PowerBI Guru's

I am having trouble with getting my row-level totals to be correct.  It seems simple enough but I cannot win.

I have a measure:

Additional Oranges required = 

IF(Sales[Pipeline vs Target]/Sales[Hitrate]<=0, 0, Sales[Pipeline vs Target]/Sales[Hitrate])

As an example, in my first row, the value for Sales[Pipeline vs Target] is 1,454 and the value for Sales[Hitrate] is 2%.

The expected result should be 72,700 but I keep getting a total of 96,276.

I have tried creating a column instead of a measure.  I have played around with calculate instead of IF but with no luck.

[selimovd]

Hey @Anno2019 ,

can you show the table and the measure?

Otherwise you could try as a measure:

Adiitional Oranges required = SUMX(Sales, Sales[Pipeline vs Target] / Sales[Hitrate])

Best regards

Denis

[Anno2019 · Accepted solution]

@selimovd 

I tried SUMX, it just does not work.

I have been playing around and noticed something.

If I bring my data in as one table, do the calculations then it works.  But in my working pbix I bring in the two product data I need and append them into a final file.  it is in the final file that the calculation will not work.  Do you think it has anything to do with how the data is brought in?

[selimovd]

Hey @Anno2019 ,

it's hard to say anything if you don't show us something.

Why the SUMX didn't work? Did you get an error message? Can you show a screenshot?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anno2019]

@selimovd 

My apologies, it worked, I was applying it incorrectly.

[selimovd]

Hey @Anno2019 ,

I'm happy it works 😊

Can you please mark the answer with the SUMX formula additionally as solution? Like this the next person who stumbles across the post can see immediately what worked for that problem.

Thank you and best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic