Forum Discussion
Add a measure as a column into a matrix
My table where I have the data is like this:
| Product ID | Category | Aisle movements | Flag |
| 1 | Carrot | Before movements | 1 |
| 1 | Carrot | To left | 1 |
| 1 | Carrot | Removed | 0 |
| 1 | Carrot | From left | -1 |
| 2 | Chilli | Before movements | 1 |
| 2 | Chilli | Removed | -1 |
I simply would like to make a matrix that would take Product Category as rows, Aisle movement as columns and sum of flag as matrix. Then I would like to calculate (sum of flags that are < 0) / (sum of before movements) to see how much % of the products have moved away from their previous position. I would want this as 1 single column added at the end of the matrix:
| Product Category | Before movements | To left | From left | Removed | Total | Moved % |
| Carrot | 1 | 1 | -1 | 0 | 1 | =-1/1 = -100% |
| Chilli | 1 | 0 | 0 | -1 | 0 | = -1/ 1 = -100% |
I have written a measure for this:
Moved % = calculate(sum(tbl[Flag]), tbl[Flag] < 0) / CALCULATE(SUM(tbl[Flag]), tbl[Aisle movements] = "Before movements")
Anonymous , seem like you are looking for Hybrid Display
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
2 Replies
- amitchandak
Super User
Anonymous , seem like you are looking for Hybrid Display
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc