How to filter entire visual on the basis on minimum value from one column

[gauri]

Hello All,

I am facing this issue :

from the Screen shot below i have a single facilityname as A, the values which are displayed are for 1 particular resident which has different sort value and icd code value. i need to display the residents details in such a way that evertime for each resident it should pick value of icd code which has minimum sort number. Here in this case the minimum sort number is 11 so i would be displaying on that paerticular icd code with teh resident name.

Can someone help me this scenario.

Thanks

[v-kelly-msft]

Hi  @gauri ,

Try measure as below;

measure =
var _min = minx(Filter(all(Table),'Table'[Facility name]=MAX('Table'[Facility name])&&'Table'[resno]=MAX('Table'[resno])),Table[sort])
return
calculate(MAX(Table[icd code]), filter(all(Table),Table[sort]=_min))

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak · Accepted solution]

@gauri , Add a measure like this

measure =
var _min = minx(allselected(Table),Table[sort])
return
calculate(countrows(Table), filter(allselected(Table),Table[sort]=_min))

Or all measure you want ; should use this filter condition

[Anonymous]

Very helpful, I could solve my problem too with this information. Thank you so much!

[gauri]

@amitchandak 

i tried this measure, aaplied filter on resident number too which workd fine, but when i select resno number in the slicer then it gives me perfect value for icd code according to min sort value, but as soon as i remove slicer of resno i should be able to see all the residents in that time period but i am not able to.