DAX - Substraction

[Anonymous]

Dear all,

I'm looking to Subtract the "MAX" from the "MIN" but excluding "0" otherwise I can't calculate the sum of the kilometres driven during a period. If someone has an idea it would be highly appreciated. I thought maybe to work with an "IF" formula but I'm not sure if this would be the way to go. Also I can't put a filter on "Kilometerstand" as I have other columns with values which would disapear.

Thanks in advance for your support.

Example

Measure

[Ashish_Mathur]

Hi,

Share the download link of your PBI file and show the expected result very clearly.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _maxvalue=MAXX(ALL('Table'),[Kilometerstand])
var _minvalue=MinX(FILTER(ALL('Table'),[Kilometerstand]<>0),[Kilometerstand])
return
_maxvalue- _minvalue

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly