topic Re: Creating a Measure to Identify How Many Vehicles are Overmileage in DAX Commands and Tips

Creating a Measure to Identify How Many Vehicles are Overmileage

Owensj241 — Wed, 16 Jul 2025 14:38:05 GMT

I need to create a measure that allows me to identify how many vehicles in a report are over mileage.

I also need to to be able to identify the # of overmileage vehicles by division.

Can someone assist with the formula I would need to use?

Thanks

Re: Creating a Measure to Identify How Many Vehicles are Overmileage

Greg_Deckler — Wed, 16 Jul 2025 14:48:20 GMT

Owensj241 Would need sample data but should look something like the following:

Measure = VAR __Over = 200000 //whatever overmileage is VAR __Table = FILTER( 'Table', [mileage] > __Over ) VAR __Result = COUNTROWS( __Table ) RETURN __Result

Re: Creating a Measure to Identify How Many Vehicles are Overmileage

Owensj241 — Wed, 16 Jul 2025 15:06:08 GMT

Odometer	Manufacturer	Model	Division
124292	CHEVROLET	IMPALA	Surveillance
251653	CHEVROLET	SUBURBAN	Swat
227201	CHEVROLET	EXPRESS 2500	Swat
219570	CHEVROLET	EXPRESS	Swat
216422	CHEVROLET	TAHOE	Field
208034	CHEVROLET	TAHOE	Field
199035	CHEVROLET	EXPRESS 2500	Field
193810	FORD	EXPLORER	Field
191867	FORD	F-150	Field
191500	FORD	F-150	Field
190343	FORD	EXPLORER	K9
189558	CHEVROLET	SUBURBAN	Surveillance

Re: Creating a Measure to Identify How Many Vehicles are Overmileage

Greg_Deckler — Wed, 16 Jul 2025 15:44:39 GMT

Owensj241 Based on that data, the following measure returns 5:

Measure = VAR __Over = 200000 //whatever overmileage is VAR __Table = FILTER( 'Table', [Odometer] > __Over ) VAR __Result = COUNTROWS( __Table ) RETURN __Result

Re: Creating a Measure to Identify How Many Vehicles are Overmileage

v-kathullac — Mon, 21 Jul 2025 12:02:31 GMT

Hi Owensj241 ,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.

Thanks

Re: Creating a Measure to Identify How Many Vehicles are Overmileage

Owensj241 — Mon, 21 Jul 2025 13:20:35 GMT

Thanks for your help! It worked.