Forum Discussion

GKs's avatar
GKs
Frequent Visitor
6 years ago
Solved

Sum Unique Quantity for Total Correct

I have worked with this for a couple of days and I really can't find the solution. I appreciate the support you can give me. In a data that has the color, id number and quantity I am trying to unify...
Need Help
  • lc_finance's avatar
    lc_finance
    6 years ago

    Hi GKs 

     

    Maybe there was a problem with the previous link. Can you try this one?

     

    Let me know if it works

     

    LC

lc_finance's avatar
lc_finance
Solution Sage
6 years ago

Hi GKs ,

 

 

I apologize for the late reply.

 

I tried to modify the formula on the old example, you can download it from here.

It's quite a complicated formula, so I used the old example as it has fewer rows so it's easier for testing and understanding the formula.

 

Can you let me know if that is what you are looking for?

 

LC

 

 

GKs's avatar
GKs
Frequent Visitor
6 years ago

id used as filter the formula does what is expected but if you take the id from the box or filter the value is equal to the second.
In essence, what is expected is to see a total real value without the need to filter id by id.
The formula is the ideal I keep using it to see if I can perform the calculation as expected.
I think the topic would be SUMX since it is adding a whole or maybe doing a SUM with FILTER.

  • lc_finance's avatar
    lc_finance
    Solution Sage
    6 years ago

    Hi GKs 

     

    Maybe there was a problem with the previous link. Can you try this one?

     

    Let me know if it works

     

    LC

  • lc_finance's avatar
    lc_finance
    Solution Sage
    6 years ago

    Hi GKs 

     

    Based on the Power BI I sent yesterday, Third is no longer equal to Second even if Id is taken away from the table.

     

    In the example, the total for Third is 84 and the total for Second is 241.

    84 is the sum of 68 for transaction 8326 and 16 for 8468.

     

    A paste a screenshot below.

     

    Is this what you are looking for?

     

    LC

  • GKs's avatar
    GKs
    Frequent Visitor
    6 years ago

    Yes, you did it.
    But you won't believe me for some reason, my Power BI doesn't SUM well, download the file I did't make any modification just remove the id from the table. I don't know why this happens, If it's an update that I don't have or maybe I did.