Forum Discussion
Slow visual calculation (PREVIOUS and RUNNINGSUM)
- 3 months ago
You need to avoid a RUNNINGSUM as that is an inherently expensive operation. If what you are trying to achieve is to visually highlight when rows belong to the same or different people, I think I would assign each person a colour, so that no matter what the order of the visual is the same person always has the same colour.
I think you could do this by using the RANK method I proposed and applying the MOD logic within the measure, or using some other way to turn a unique Person Key into a unique colour.
Hi @kleigh ,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support