How to get total sum per vendor

[non23]

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	5/2/2024	3000
3	9/1/2001	4000
4	7/7/2023	4212
5	12/12/2012	3500
1	1/1/2001	1232132

I want to have a table as a visual where it will show the total sales of vendor regardless of the date. Everything is in one table. Tried to use 
Total Sales Per Vendor =
CALCULATE(
SUM(Sales[TotalSales]),
ALL(Sales[DueDate]), -- Remove any filter from Due Date
VALUES(Sales[Vendor]) -- Keep the vendor context
)

but when I changed the DueDate slicer the value also changed. 

[Anonymous]

Hi @non23 ,

May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster .

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[divyed · Accepted solution]

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

[Jihwan_Kim]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

expected result measure: =
CALCULATE (
    SUM ( SalesFact[Sale] ),
    ALL ( PeriodDimension[Date] )
)

[Irwan]

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.