Default filter -- based on max/min value

[carlol]

I have RLS implemented 

The issue is for a user with all Access , I do not want to illustrate a graph with all options , too busy 

My Solution is to idenify the max ID assocaited with the Filter , have a generic name "Default" ; regardless of the options avaialble , it will always illustrate Default option based on what the user has access to 

Having issue with DAX

Something like this 

Max = VAR HospIDMax = Calculate(Max(DimHospital[HospitalID]),FILTER(DimHospital,DimHospital[Hospital]<>"National"))

RETURN

IF( DimHospital[HospitalID] = HospIDMax), "Default",

DimHospital[Hospital]

)

[carlol]

Thanks will give it a try and let you know how I get on

[v-eqin-msft]

Hi @carlol ,

Could you tell me if @VahidDM 's post helps you? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[VahidDM · Accepted solution]

Hi @carlol 

Try this:

Max =
VAR HospIDMax =
    CALCULATE(
        MAX( DimHospital[HospitalID] ),
        FILTER( DimHospital, DimHospital[Hospital] <> "National" )
    )
VAR _M =
    MAX( DimHospital[HospitalID] )
RETURN
    IF( _M = HospIDMax, "Default", _M )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/