Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
i'm trying to bring this query
CASE sum(ANAR.SFRIDO)
when 0 then sum(Vendite.Cost)
else sum(Vendite.Cost+Vendite.Cost*ANAR.SFRIDO/100)
end
Vendite and ANAR are the table. Cost and SFRIDO are the columns
I understood that i have to use SWITCH but i don't understand how to put togethere switch with sum and arithmetic operators of the original query. How can i transform this query that come from sql server to power bi?
Thank you a lot !
Solved! Go to Solution.
Measure_Name =
Var _SFRIDO = SUM(ANAR[SFRIDO])
Var _COST = SUM(Vendite[Cost])
return
IF(_SFRIDO = 0, _COST, _COST +_COST * _SFRIDO / 100
Please optimize the measure.
Measure_Name =
Var _switchValue = SUM(ANAR[SFRIDO])
return
IF(_switchValue = 0, SUM(Vendite[Cost]), Vendite[Cost]) + MAX(Vendite[Cost]) * _SFRIDO / 100
Sorry, I had written the wrong table name by writing “max” but it was wrong, now I removed it and wrote the correct table name i.e. “Sales”. Why do you use the MAX function? Thank you
Measure_Name =
Var _SFRIDO = SUM(ANAR[SFRIDO])
Var _COST = SUM(Vendite[Cost])
return
IF(_SFRIDO = 0, _COST, _COST +_COST * _SFRIDO / 100
Thank you, it seems working.
What about this other query? I don' t understand how to arrasnge this one. Can you help me?
SQL SERVER:
sum(CASE WHEN anama.ppcoll is null
THEN 0
ELSE
case when anama.ppcoll <> 0
then Vendite."Quantità"/ anama.ppcoll
else 0
end
END)
Thanks!
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
47 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |