count of individuals that meet daily performance parameters, date range set by page slicers

[Anonymous]

My aim is to get a count of individuals (in this case, vehicles) that failed over 10% of daily checks, with the date range for the daily checks set by a page slicer. In the image example below, this measure should yield 11. After that, it would be ideal if I could make a slicer or checkbox to filter other visuals to only show data for those vehicles. I've been trying for a long time with temp tables, but nothing has worked yet. I would very much appreciate any ideas! Thank you

[amitchandak · Accepted solution]

@Anonymous , Not very clear. Try if this can help

countx(filter(values(Table[vehicle]),[failed %]>10),[vehicle])

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490