Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX HELP

Below formula giving wrong value. Please help   INVOICED QTY = CALCULATE(SUM(SO_BI_FACT[QTY]), FILTER(SO_BI_FACT, SO_BI_FACT[CLASSIFICATION] <> "C&I" && SO_BI_FACT[FLAG]=1 )) + CALCULATE(S...
Need Help
  • shebr's avatar
    shebr
    6 years ago
    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?

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Already restricted in the below formula. But still it is considering flag = 0 also.
var one = CALCULATE(SUM(SO_BI_FACT[QTY]),
FILTER(SO_BI_FACT,
SO_BI_FACT[CLASSIFICATION] <> "C&I"
&& SO_BI_FACT[FLAG]=1 ))
shebr's avatar
shebr
Resolver III
6 years ago

If you see this image it is not including SO ID 4.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, the formula is ok. But still adding that qty also.

    I dont know, why the formula is considering this record also.

  • shebr's avatar
    shebr
    Resolver III
    6 years ago

    Can you show me a screen shot of your data table? Do you have any filters applied? Are your data formats in the right format? Check if your 'Flag' is text or numeric. 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Sorry bro, formula is fine. Source data is wrong.

  • shebr's avatar
    shebr
    Resolver III
    6 years ago

    No Problem, I thought I was going crazy.


    ** Did this answer your question, mark as resolved and hit the Kudos button!**