% Of total help

[SupermercadosV]

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 % of Sales, the problem is that when i applied the filter with all(store) and all(dayofweek) give me the total of each day of week overall and i need the total of all day of week only the each store. For example 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.

 

Cordially B. Estevez

[v-yulgu-msft]

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]

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]

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

[SupermercadosV]

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]

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 % of Sales, the problem is that when i applied the filter with all(store) and all(dayofweek) give me the total of each day of week overall and i need the total of all day of week only the each store. For example 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.

Cordially B. Estevez