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

     

     

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/