The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
Solved! Go to 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 , please replace the measure with your calculation of your current meausre
Try like
calculate([Measure], allselected(Table))
calculate([Measure], allselected(Table[date]))
@amitchandak my solution ended up not working in the end - yours worked well. thanks!
User | Count |
---|---|
86 | |
84 | |
35 | |
35 | |
34 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
52 |