Forum Discussion
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 highl...
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- _minvalue2. 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
Hi,
Share the download link of your PBI file and show the expected result very clearly.