Using ABS Function in DAX Measure

DAX DAX Calculations
2

Hi @ambidextrousmentally,

Just wrap ABS around CALCULATE

Net Timing =
    ABS( 
        CALCULATE( SUM( metricssalescustomer[amount] ),
            metricssalescustomer[sales_type_lvl1] = "Lost - Timing"
            || metricssalescustomer[sales_type_lvl1] = "Decline - Timing"
            || metricssalescustomer[sales_type_lvl1] = "Upsell - Timing"
            || metricssalescustomer[sales_type_lvl1] = "New - Timing"
        )
    )

I hope this is helpfuf

1 Like