Measure value changing

[melanie-g]

Hi there

I want to create a measure for PVR benchmark, that displays different values for the Grouping Level (see below screen shot).

The first category is State

The second category is Site

The third category is Product

Each product listed is either Luxury or Non Luxury.

If a product is Luxury, the benchmark should be $1000.

If a product is Non Luxury, the benchmark should be $350.

If you are looking at the Site or State result total, the benchmark should be $550.

So in my example below, if the products are Non Luxury, I want each product line to show $350 instead of $550. 

Any help would be appreciated.

Thanks. 

Melanie

[amitchandak · Accepted solution]

@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/