Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX - Substraction

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

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