How to calculate by an aggregated DAX measure?

[AlexH330]

Hello,

I have a DAX measure (very basic subtraction measure) that I'd like to roll up and calculate using that rolled up value.

Right now, it's being calculated in the same context as my rows (as expected), but I'd like each row to be calculated by the rolled up value instead. I feel like this is basic, but I can't get it to work. Right now it looks like this:

Date	Value	Measure
Day 1	2	1
Day 2	4	1
Day 3	7	2
Day 4	6	2

And I want it to look like this:

Date	Value	Measure
Day 1	2	1.5
Day 2	4	1.5
Day 3	7	1.5
Day 4	6	1.5

[amitchandak · Accepted solution]

@AlexH330 , please replace the measure with your calculation of your current meausre

Try like

calculate([Measure], allselected(Table))

calculate([Measure], allselected(Table[date]))

[AlexH330]

@amitchandak my solution ended up not working in the end - yours worked well. thanks!