Fill down the sum of a measure into blank cells

[Nichlasrb]

Hi BI Community,

Ive been looking for a solution to this problem for the last two weeks now, and havent been able to find any other thread with 100% similarity - so i really hope you can help me out on this one.

I have computed a DAX to calculate the sum of contracts won target which looks the following:

My Question is now, is it possible to fill down the value from the DAX in the following table:

The idea is that the contracts won target will be dynamic and changing corresponding to a filter that filters down a sales person.

Thanks in advance!

 

[v-yalanwu-msft]

Hi, @Nichlasrb ;

I am very glad that your problem has been solved. can you mark your reply as a solution to help others having the similar issue and close the case? 

Thank you!

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi， @Nichlasrb ；
If you want to fill in the blanks, you can use AllSELECTED(). Can you try it and if it fails to solve, can you share a simple file and want to output the results to show? In order to facilitate a better understanding of the logic and solve it.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Nichlasrb · Accepted solution]

Hi @v-yalanwu-msft 
It was solved through some SQL-coding. But thanks for the reply

BR