Forum Discussion
Solved
VALUES with Filter
Hi I have the following table I need to calculate the unique count of vechiles opened cards after 100,000 ODO Reading as long as they opened cards before 100,000 ODO r...
Hi amaniramahi
Try this measure:
Count = Var _MinV = filter('Table','Table'[ODO Reading]<10000) Var _MaxV = filter('Table','Table'[ODO Reading]>10000) return CALCULATE(DISTINCTCOUNT('Table'[VIN]),EXCEPT(all('Table'),EXCEPT(_MaxV,_MinV)))Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Hi amaniramahi
Try this measure:
Count =
Var _MinV = filter('Table','Table'[ODO Reading]<10000)
Var _MaxV = filter('Table','Table'[ODO Reading]>10000)
return
CALCULATE(DISTINCTCOUNT('Table'[VIN]),EXCEPT(all('Table'),EXCEPT(_MaxV,_MinV)))
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
THANK YOU!
all I was thinking about is how to use VALUES with a filter!
