Forum Discussion
Year over year calculation with multiple slicers
Hi johnbasha33 , thank you for your response.
The new measures for base year and comparison year may not be working correctly, as the cards only show accurate values when I edit slicer interactions so that the topic and date slicers affect them. Otherwise, they're showing static values. My understanding may be incorrect, but shouldn't they work without the slicers acting on them, and if they need the slicers, then is the correct value really being returned by the measure?
The YoY calculation is returning zero no matter what since the base and comparison values aren't working.
I've attached some screenshots to show you what all my measures and visuals look like. Thank you so much for your help!
Hi acrinard,
Thanks for reaching out to the Microsoft fabric community forum.
Just following up to your previous messages, I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
I would also take a moment to thank johnbasha33, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
If this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.