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?

shebr's avatar
shebr
Resolver III
6 years ago

Of course if different values appear in the data you need to handle this in the measure. Either you can add it as an additional variable (VAR) See my example, or you can add it in the FILTER formula.

 

Does that make sense?

 

If you can provide the FULL specs then I can give a complete answer, otherwise it will not be complete.

 

Thanks

 

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!**