Forum Discussion

SupermercadosV's avatar
SupermercadosV
Frequent Visitor
8 years ago

% Of total help

Hi,   i need to help to solve a question. In this case i have  a matrix the first row show the store the next one day of week and then i have a column through the years. The measure are Sales and %...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi SupermercadosV,

 

Would you please post some dummay data stored in source table rather than just data in visual? Also, please show us your desired result with examples, as I cannot understand " if the first store sells 10000 i need divide the sale of monday / 10000, and if the second store sells 11000 i need divide the sale of monday / 11000 for this store".

 

Regards,

Yuliana Gu

  • SupermercadosV's avatar
    SupermercadosV
    Frequent Visitor
    8 years ago

    Hi again,

     

    the dummay data stored are here:

     

    I need to find the correct solve to calculate Peso Venta, at this moment i have this that is wrongAnd i need take the next one

     

     

     

    I wish I'd explained myself correctly

     

    Thanks so much for the response

     

     

     

     

     

  • SupermercadosV's avatar
    SupermercadosV
    Frequent Visitor
    8 years ago

    Hi again,

     

    the dummay data stored are here:

     

    I need to find the correct solve to calculate Peso Venta, at this moment i have this that is wrongAnd i need take the next one

     

     

     

    I wish I'd explained myself correctly

     

    Thanks so much for the response

     

     

     

     

     

    • SupermercadosV's avatar
      SupermercadosV
      Frequent Visitor
      8 years ago

      the dax formula I used was the following:

       

      Var ventas = SUM(Tabla_Ventas[Imp. Venta])

      Var allSalesWeek = CALCULATE(SUM(Tabla_Ventas[Imp. Venta]); ALLEXCEPT(Tabla_Calendario; Tabla_Calendario[Semana]; Tabla_Calendario[Año]))

      Return

      DIVIDE(Ventas; allSalesWeek;0)

       

      Thanks for all