Forum Discussion
Measure value changing
melanie-g , Based on what I got a new measure
A new measure = Switch(True() ,
isinscope([Product Type]) && Max(Table[Product Type])= "Luxury" , 1000 ,
isinscope([Product Type]) && Max(Table[Product Type])= = "Non Luxury" , 350,
550)
How to use insinscope
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
melanie-g , Based on what I got a new measure
A new measure = Switch(True() ,
isinscope([Product Type]) && Max(Table[Product Type])= "Luxury" , 1000 ,
isinscope([Product Type]) && Max(Table[Product Type])= = "Non Luxury" , 350,
550)
How to use insinscope
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/