Diferent filter for the same variables

[Pablo_Quintana]

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

[Fowmy]

@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

[Pablo_Quintana]

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

[Fowmy · Accepted solution]

@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 

[Pablo_Quintana]

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