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