cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Apply measure to several categories based on one specific category

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.

2 ACCEPTED SOLUTIONS
Frequent Visitor

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.

Super User

@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:

4 REPLIES 4
Super User

@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.

Frequent Visitor

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.

Super User

@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:

Frequent Visitor

This works! Fantastic. Thank you 🙂