Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Solved! Go to Solution.
Hi @PBI-Curious ,
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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" }
)
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" }
)
Hello Alexis
Will give it a try.
Thank you
Hi @PBI-Curious ,
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi Samarth
Got it to work, much appreciate your help!
Thank you
I notice you are a Memorable Member, what does that mean?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |