@TarasHrytsak , Yes use isinscope or isfiltered if needed
Use for all the rows in if and do for each
for each measure
if(not(isinscope(Table[Month])), [Total measure], [Target revenue])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
✨️ November 12th-14th, 2024
Online Event
Register Here
