Apply measure to several categories based on one specific category

[sindrekb]

Hi, 

I have a model for presenting the development of overdue accounts receivables by month, and overdues today (Baan - Current) in the included snip. My business has set a target of 10 % reduction of overdue balance from Year Start to year end. I would like to create a measure which calculates 90 % of open overdue amount at year start (413,25 million --> 90 % of 459,17 million) which applies to all periods as shown in the snip below. 

Thank you. 

 

[sindrekb · Accepted solution]

This will apply to all periods, but will show 90 % of the Open amount per period, and not 90 % of the open amount for year start - equal to 413 mill, which I need to be applied to all categories.

[Anand24]

@sindrekb ,
Not sure if I completely understood your query but is this what you are looking for? 

Target Test = SUM(TableName[Open Amount]) * 0.9

This will provide you 90% of open amount.

[sindrekb · Accepted solution]

This will apply to all periods, but will show 90 % of the Open amount per period, and not 90 % of the open amount for year start - equal to 413 mill, which I need to be applied to all categories.

[Anand24 · Accepted solution]

@sindrekb ,
Try this in a new calculated measure:

Target Test =
CALCULATE(
    SUM(ar_db[Open Amount]) * 0.9,
    ALL(ar_db),
    ar_db[Development Status] = "Year start"
)

Output:

[sindrekb]

This works! Fantastic. Thank you 🙂