topic Re: How to get total sum per vendor in DAX Commands and Tips

How to get total sum per vendor

non23 — Tue, 22 Oct 2024 23:43:39 GMT

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.

Re: How to get total sum per vendor

Irwan — Wed, 23 Oct 2024 00:22:13 GMT

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.

Re: How to get total sum per vendor

Jihwan_Kim — Wed, 23 Oct 2024 04:50:51 GMT

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

Re: How to get total sum per vendor

divyed — Wed, 23 Oct 2024 06:01:39 GMT

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

Re: How to get total sum per vendor

Anonymous — Mon, 28 Oct 2024 09:10:43 GMT

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.