Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
21 | |
20 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
27 | |
23 | |
22 | |
22 |