Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate Problem

Hello,   I have a simple problem.  I want to calculate the totals of the QuantityAllocated column according to each different container number     When I click on a row it gives the total...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , what is the structure of your data.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak 

    Sorry I can't share. I get the data from the database with direct query. What I want is the sum of the QuantityAllocated columns for according to each different container column.

    So; In the following filtering result, normally the Quantity Allocated quantity sum should be 39.720, but the result is 158.888 😞