Calculate a measure by individual date period, instead of calculate over entire table

grubpot — Wed, 08 Jan 2020 13:18:04 GMT

Hello,

A follow up question for an item I posted that was 90% solved!

I have a measure that I need to summarise by date. Instead of calculating over the entire table.

I can't see how to insert sample file, so below is some example data:

Current data structure has product, customer, date, forecast and ordered quantity.

Then my measure works out the ordered vs forecast at product level.

a +/-15% difference between forecast and ordered is acceptable.

then finally, this is the resuly I need. The number of products that hit the target +/- 15% by date.

I have a formula for the measure, but it only looks at the entire block of data, whereas I need to summarise by date.

	Total products ordered	Number of products in acceptable tolerance	Tolerance Rate
01-Jan	3	1	33%
02-Jan	3	3	100%
03-Jan	3	1	33%
Grand Total	9	5	56%

Would anyone have any idea how to achieve this?

Many thanks

Re: Calculate a measure by individual date period, instead of calculate over entire table

grubpot — Wed, 08 Jan 2020 13:15:55 GMT

If I put my measusre into a table it gives the correct result for the individual dates.

However the total does not work - it looks at all the data together instread of the total of each individual result.

grubpot — Thu, 09 Jan 2020 10:43:56 GMT

Hi,

I found a solution... the solution was to use summarize!

Accuracy count =

VAR summarizedTable =

SUMMARIZE('Weekly Forecast Accuracy set datesnew','SAP dates'[Week / Yr],"Count acc", [Count in tolerance])

RETURN

SUMX(summarizedTable,[Count in tolerance])