DAX HELP

---

shebr wrote:

Hi Anonymous 

 

Can you try this as a measure? Let me know how you get on? Are you expecting 1700 as your value?

 

My Calc =

var one = CALCULATE(SUM(SO_BI_FACT[QTY]),

FILTER(SO_BI_FACT,

SO_BI_FACT[CLASSIFICATION] <> "C&I"

&& SO_BI_FACT[FLAG]=1 ))

VAR two = CALCULATE(SUM(SO_BI_FACT[QTY2]),

FILTER(SO_BI_FACT,

SO_BI_FACT[CLASSIFICATION] = "C&I"))

return CALCULATE(one + two, ALL(SO_BI_FACT))

---

Anonymous did you try this measure?