User Profile
SonyT01
Regular Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Last 12 Months of Sales into Bins
Hi Amit, Thank you for your links. I tried applying one of your measures by switching the AVERAGEX with a SUMX but it's not recognising my 'Bins' table. Can you see where I might have gone wrong in my measure below? The column 'Customers'[Customer Name Grp1] is a text field so does that have something to do with it? Thank you.Last 12 Months of Sales into Bins
Hi, I would like to be able to allocate our last 12 months of sales into the below bins. I have managed to do this by customer count but due to my lack of knowledge of DAX, I can't seem to work out how to do this with the sales amount. The customer count measure that works perfectly is this: Count of Customers by Sales Bin = SUMX (Bins, COUNTROWS(FILTER(SUMMARIZE(Customers, Customers[Customer Name Grp1]), SalesSplitPrep[Total Sales Last 12 Months] >= Bins[Min Value] && SalesSplitPrep[Total Sales Last 12 Months] < Bins[Max Value]))) But how do I do this with Sales ie allocate the 'sum of the last 12 month sales by customer' into the below bins? It's important that the last 12 mths of sales are grouped by Customer Name Grp1 and Sale_type before determining the sale size/bin. The 'Bins' table looks like this. The 'SalesSplitPrep' table looks like this: My end goal is to create a matrix that is similar to this, showing sales $$. Hope someone can help. 🙂Combinar celdas en la visualización de matrices: muestra texto común combinado entre celdas en una fila
Hola. ¿Es posible combinar celdas a través de una fila en una visualización de matriz para que muestre el texto común solo una vez? No quiero que el texto se repita en cada celda. Se puede hacer en ecel, pero me gustaría hacerlo en Power BI si es posible. Ejemplo en Excel. Así es como se ve en Power BI. Me gustaría ser capaz de fusionar de alguna manera la descripción como arriba en Excel. Cualquier idea sería muy bienvenida. Gracias.Merge cells in matrix visualisation - show common text merged across cells in a row
Hi. Is it possible to merge cells across a row in a matrix visualisation so that is displays the common text only once? I don't want the text to be repeated in every cell. It can be done in ecel but I would like to do this in Power BI if it's possible. Example in excel. This is how it looks in Power BI. I would like to be able to somehow merge the description as above in excel. Any ideas would be very welcome. Thank you.
