topic Re: Using * -1 with a Dax measure in DAX Commands and Tips

Using * -1 with a Dax measure

Anonymous — Mon, 24 Jan 2022 18:39:48 GMT

Power BI Community Good Day!

The Dax below is giving me a positive value. What do I have to do to modify the Dax with * -1 to make it a negative value?

Net Timing = 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")

Much appreciate your time

Thank you

Re: Using * -1 with a Dax measure

Samarth_18 — Mon, 24 Jan 2022 19:14:53 GMT

Hi Anonymous ,

You can try below code:-

Net Timing = VAR result = 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" ) RETURN result * -1

Thanks,

Samarth

Re: Using * -1 with a Dax measure

Anonymous — Mon, 24 Jan 2022 19:41:30 GMT

Hi Samarth

Got it to work, much appreciate your help!

Thank you

I notice you are a Memorable Member, what does that mean?

Re: Using * -1 with a Dax measure

AlexisOlson — Mon, 24 Jan 2022 22:09:23 GMT

You can just stick a "-" in from of CALCULATE or SUM too but you may want to keep more visible than just a single character.

I'd probably do something like this:

Net Timing = CALCULATE ( -1 * SUM ( metricssalescustomer[amount] ), metricssalescustomer[sales_type_lvl1] IN { "Lost - Timing", "Decline - Timing", "Upsell - Timing", "New - Timing" } )

Re: Using * -1 with a Dax measure

Anonymous — Tue, 25 Jan 2022 02:39:00 GMT

Hello Alexis

Will give it a try.

Thank you