Forum Discussion

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...

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

Solution Sage

6 years ago

Hi GKs ,

I just checked and your Google Drive file is private.

Let me know when you make it public so I can access it,

LC

Frequent Visitor

6 years ago

Please try again, thanks you for your help

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