Help for calculating weighted sales

[Syndicate_Admin]

Hello:

I am new to Power BI, I have an example of sales by country and when calculating sales the result is correct.

I also have a group of sellers 1 per country, but there is a country where there are 2 sellers in the country, in order to calculate your sale there is a field called WEIGHTING, which must multiply the sale by the WEIGHTING and is the correct result.

When doing it with DAX, I have not had the desired result, I have tried, sumx and related but they have not worked as I expect.

I forgot to comment that my model is in three tables. Someone could help me, I don't know how to approach the problem correctly.

Greetings and thanks in advance.

Data CloudStalemateVerification and desired result

[johnt75]

Try defining a measure as

Total Sales = SUMX( Ventas, Ventas[CANTIDAD] * SELECTEDVALUE( Vendedores[PODERACION), 1) )

[Syndicate_Admin]

Thank you for your answer I worked halfway the solution, when removing the dimension of WEIGHTING from the table the result looks white and without subtotals in a matrix, I imagine that this is because it needs this dimension to be able to perform the multiplication correctly and not having it can not show the result. How it can be adjusted so that it gives the correct result???

[johnt75]

The measure I defined is using 1 as the default if no weighting is found, so I don't think that that is the problem. Can you share a screenshot ?

[Syndicate_Admin]

Hello:

Look at these data do not match when I put the formula in a contracted vs expanded matrix, following the same DAX, on the other hand when he adds to the model other data where the seller can have more than one country or more than 2 weights, he begins to put blank data. it is worth mentioning, that the data I show are from a demo and not the real ones.

Any idea of how to adjust the formula?

Thank you very much and greetingsNew error