cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Calculate data values from measures doesn't match

Dear All,

I am trying to create a formula that calculates the cost on a revenue days to late.

To creat this formula I made a few measures:

- Average revenue per day
- Average day's to late
- Total revenue per day to late.

These measures I created:

Average revenue per day = SUMX('Document Data','Document Data'[Amount in]/365)
Average days to late = AVERAGE('Document Data'[Days to late])

The above 2 measures work, but on the next one I want to calculate the "cost" of revenue we miss because of late payments:
Total revenue per days to late = SUMX('Document Data',[Average revenue per day]*[Average days to late])
In my opinion this formula should be correct, but it looks like it calculates diferend value's than the measures show.

I have set the values in cards to show the results

If I make a calculation like my measure I do receive a different amount
Total revenue per days to late = SUMX('Document Data',[Average revenue per day]*[Average days to late])

= SUM 7.09k*0.84=5.96k

So somehow I might forget something or it might calculate form other customer data (there is more customer data in my sheet).

Could someone help me with this issue?

Thanks!
Ramon
2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IX

## Re: Calculate data values from measures doesn't match

@RNooijen , I need some data to understand the problem. Can you share sample data and sample output in table format?

Now the product is always correct at line level means

SUm(A*B), NOT Sum(A)*Sum(B)

So in case you have to do Sum(A)*Sum(B) then you need to use context with values or summarize

Proud to be a Super User!

Highlighted
Super User VI

## Re: Calculate data values from measures doesn't match

Total Revenue to Late = [Average Revenue Per Day] * [Average Days To Late]

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Proud to be a Super User!

4 REPLIES 4
Highlighted
Super User IX

## Re: Calculate data values from measures doesn't match

@RNooijen , I need some data to understand the problem. Can you share sample data and sample output in table format?

Now the product is always correct at line level means

SUm(A*B), NOT Sum(A)*Sum(B)

So in case you have to do Sum(A)*Sum(B) then you need to use context with values or summarize

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: Calculate data values from measures doesn't match

I don't understand the part of SUM(A*B), NOT Sum(A)*Sum(B)

Below I have pasted a part of the data set I use in table format, is this useful?

Thanks!

 Account DocumentNo C/I Doc. Date Clearing Dun Amount PayT Days Days to late 75149089 66120774 Invoice 10/01/2020 00:00 24/02/2020 00:00 9100 45D 45 0 75174471 66123082 Invoice 14/01/2020 00:00 09/04/2020 00:00 14460 45D 86 41 75174471 66123595 Invoice 15/01/2020 00:00 11/03/2020 00:00 4650 45D 56 11 75174471 66123596 Invoice 15/01/2020 00:00 11/03/2020 00:00 8054 45D 56 11 75174471 66168226 Invoice 16/01/2020 00:00 21/02/2020 00:00 912 45D 36 -9 75174471 66168264 Invoice 16/01/2020 00:00 08/04/2020 00:00 4395 45D 83 38 75174471 66168299 Invoice 16/01/2020 00:00 11/03/2020 00:00 5096.5 45D 55 10 75149089 66128697 Invoice 21/01/2020 00:00 06/03/2020 00:00 67.5 45D 45 0 75149089 66128716 Invoice 21/01/2020 00:00 06/03/2020 00:00 3190 45D 45 0 75149089 66128749 Invoice 21/01/2020 00:00 06/03/2020 00:00 180 45D 45 0 75174471 66129215 Invoice 22/01/2020 00:00 11/03/2020 00:00 3997.5 45D 49 4 75174471 66129216 Invoice 22/01/2020 00:00 11/03/2020 00:00 6467.5 45D 49 4 75174471 66156268 Invoice 24/01/2020 00:00 24/02/2020 00:00 4274 45D 31 -14 75149089 66134708 Invoice 28/01/2020 00:00 13/03/2020 00:00 4765 45D 45 0 75149089 66134712 Invoice 28/01/2020 00:00 13/03/2020 00:00 7885 45D 45 0 75149089 66134737 Invoice 28/01/2020 00:00 13/03/2020 00:00 1700 45D 45 0 75174471 66135116 Invoice 29/01/2020 00:00 11/03/2020 00:00 79095.5 45D 42 -3 75174471 66135117 Invoice 29/01/2020 00:00 11/03/2020 00:00 6565 45D 42 -3 75149089 66143650 Invoice 07/02/2020 00:00 23/03/2020 00:00 14420 45D 45 0 75149089 66148667 Invoice 13/02/2020 00:00 30/03/2020 00:00 4315 45D 46 1 75149089 66155581 Invoice 21/02/2020 00:00 08/04/2020 00:00 3755 45D 47 2 75174471 66160226 Invoice 27/02/2020 00:00 11/03/2020 00:00 912 45D 13 -32 75174471 66160227 Invoice 27/02/2020 00:00 11/03/2020 00:00 255 45D 13 -32 75174471 66189690 Invoice 07/04/2020 00:00 30/04/2020 00:00 32.5 45D 23 -22 75149089 68630611 Invoice 05/06/2020 00:00 20/07/2020 00:00 13440 45D 45 0 75174471 68651872 Invoice 01/07/2020 00:00 31/07/2020 00:00 398 45D 30 -15 75174471 68651873 Invoice 01/07/2020 00:00 31/07/2020 00:00 922 45D 30 -15 75169632 5605127 Invoice 02/01/2020 00:00 14/02/2020 00:00 110.11 45D 43 -2 75169632 5605128 Invoice 02/01/2020 00:00 14/02/2020 00:00 1351.35 45D 43 -2 75169632 5605129 Invoice 02/01/2020 00:00 14/02/2020 00:00 7230.3 45D 43 -2 75160389 5605186 Invoice 02/01/2020 00:00 28/02/2020 00:00 50 30D 57 27 75160389 5605187 Invoice 02/01/2020 00:00 28/02/2020 00:00 383.88 30D 57 27 75160389 5605220 Invoice 02/01/2020 00:00 08/04/2020 00:00 130.4 30D 97 67 75169630 5605654 Invoice 03/01/2020 00:00 18/02/2020 00:00 318.18 45D 46 1 75169630 5605679 Invoice 03/01/2020 00:00 18/02/2020 00:00 818.8 45D 46 1 75169630 5605683 Invoice 03/01/2020 00:00 18/02/2020 00:00 1161.45 45D 46 1 75169630 5605684 Invoice 03/01/2020 00:00 18/02/2020 00:00 1517.78 45D 46 1 75169630 5605686 Invoice 03/01/2020 00:00 18/02/2020 00:00 3791.34 45D 46 1 75169630 5605687 Invoice 03/01/2020 00:00 18/02/2020 00:00 3671.57 45D 46 1 75169630 5605688 Invoice 03/01/2020 00:00 18/02/2020 00:00 8858.22 45D 46 1
Highlighted
Super User VI

## Re: Calculate data values from measures doesn't match

Total Revenue to Late = [Average Revenue Per Day] * [Average Days To Late]

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: Calculate data values from measures doesn't match

@mahoneypat,

That worked, so I think thats the same as @amitchandak meant with =Sum(A)*Sum(B).

Thanks a lot for your support!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021