Forum Discussion

carlol's avatar
carlol
Resolver I
4 years ago
Solved

Default filter -- based on max/min value

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]
)
Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    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/

     

     

3 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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/

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

  • carlol's avatar
    carlol
    Resolver I
    4 years ago

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