Forum Discussion
sum based on a measure
I have created a measure that will count the number of arrests per person based on a date range slider. That works great. Now, I need to total the number of people with the same arrest qty. belo...
Hi sc24,
This requirement is not achievable. Since you need to get the dynamical arrests total, you have to create a measure for it. But measure returns single value based on row context. In your expected output, the attemption to use measure vlaues as row context doesn't make sense.
Best regards,
Yuliana Gu
v-yulgu-msft - thanks! I created a measure because columns don't update with slider change. Is there another route I go about acheiving this without using measures and keeping the arrest count dynamic?
Hi sc24,
Is there another route I go about acheiving this without using measures and keeping the arrest count dynamic?I'm afraid not. Only measure can return results dynamically based on slicer change.
Regards,
Yuliana Gu