Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Help for calculating weighted sales

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 th...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try defining a measure as

Total Sales = SUMX( Ventas, Ventas[CANTIDAD] * SELECTEDVALUE( Vendedores[PODERACION), 1) )
  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    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's avatar
      johnt75
      Icon for Super User rankSuper User
      4 years ago

      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's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator
        4 years ago

        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 greetingsNewnuevo error error