topic Re: Diferent filter for the same variables in DAX Commands and Tips

Diferent filter for the same variables

Pablo_Quintana — Mon, 28 Sep 2020 07:48:49 GMT

Hi guys,

I'm new to DAX so help would be appreciated.

Having the followed tables: Date, sellers, and invoices, I would like to calculate the weight in the total amount of sales for this year and for each month and seller. Using 2 cards to filter the measure (date and seller) I have this function:

Weight = SUM(Invoice[Price]) / SUMX(ALL(Invoice,Invoice[Price])

But this one just shows the weight regarding the full-year sales, and I would like to overview not only the comparison with the full-year but also with a certain month using the month card.

Any ideas about how can I make this work? Thanks for your help

Re: Diferent filter for the same variables

Fowmy — Mon, 28 Sep 2020 07:54:11 GMT

Pablo_Quintana

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

Re: Diferent filter for the same variables

Pablo_Quintana — Mon, 28 Sep 2020 08:30:00 GMT

SalesID	Date	Price	Seller
5	20/08/2020	3400	A
0	28/09/2020	5000	A
1	03/09/2020	3500	A
2	12/09/2020	9000	B
3	07/08/2020	2000	B
4	18/06/2020	7000	B

Seller ID	Seller
0	A
1	B

+ Calendar table

Having 2 cards to filter the data (date month and seller )

I would like to know the weight like:

Selecting only seller card ("A" for example): (3400 + 3500 + 5000) / (3400 + 3500 + 5000+ 9000 + 2000 + 7000) <- A sales / total sales

Sales using both cards (Example "A" and september): (3500 + 5000) / (3500 + 5000 + 9000) <- A sales in september / total sales in september

Re: Diferent filter for the same variables

Fowmy — Mon, 28 Sep 2020 08:40:32 GMT

Pablo_Quintana

Apply this measure, it works for your selection of Month and Seller.

Measure % = DIVIDE( SUM(Table2[Price]), CALCULATE( SUM(Table2[Price]), ALL(Table2[Seller ]) ) )

Format your measure as %

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube LinkedIn

Re: Diferent filter for the same variables

Pablo_Quintana — Mon, 28 Sep 2020 09:14:25 GMT

Thank you very much, I didn't know you can use all filter in that way ^^