Forum Discussion
Measure behavior based on grid columns
Hello, I'm new to Power BI. I have a measure called COSTING = SUM(TABLE1.COST) Use Case: When users drags City from the Location Dimention, then do not add up the cost if ID is -1, so I modifi...
Anonymous , isfiltered /isinscope should able to help you.
like
Measure =
SWITCH (
TRUE,
ISINSCOPE ( Table[State] ), [Costing],
ISINSCOPE ( Table[City] ), [Costing1],
blank()
)
refer this example if this can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/