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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
85 | |
77 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |