Forum Discussion

non23's avatar
non23
Icon for Helper I rankHelper I
1 year ago
Solved

How to get total sum per vendor

hey guys, tried to use other solutions here but won't work on my end. please let me know if I missed a step. basically I have a table like below:   Vendor Date Sale 1 1/1/2024 5000 2 ...
  • divyed's avatar
    divyed
    1 year ago

    Hello non23 ,

     

    Considering you have a single table , you can use below dax to achieve the same.

    Total_Sales_By_Vendor =
    CALCULATE(
        SUM(Vendor_Sales[Sales]),
        ALL(Vendor_Sales[Due_Date])
    )
     

    It will ignore due_Date filter if any

     

     

     

    I hope this is what you wanted. If not, kindly share all tables and expected output to check further.

     

    Did I answer your query ? Mark this as solution if this helps, Appreciate Kudos always 🙂

     

    Cheers

     
Irwan's avatar
Irwan
Icon for Super User rankSuper User
1 year ago

hello non23 

 

try putting your 'Sales' table as ALL expression instead of 'DueDate' column.

Total Sales =
CALCULATE(
    SUM('Table'[Sale]),
    ALL('Table'),
    VALUES('Table'[Vendor])
)
 
Hope this will help.
Thank you.