topic Default filter -- based on max/min value in DAX Commands and Tips

Default filter -- based on max/min value

carlol — Wed, 01 Dec 2021 17:01:43 GMT

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]

)

Re: Default filter -- based on max/min value

VahidDM — Thu, 02 Dec 2021 12:13:52 GMT

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/

Re: Default filter -- based on max/min value

Anonymous — Tue, 07 Dec 2021 06:28:52 GMT

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

Re: Default filter -- based on max/min value

carlol — Wed, 08 Dec 2021 10:49:51 GMT

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