Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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
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
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
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
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |