Forum Discussion
Solved
Grouping figures using Filter on another column
Looking to create a measure to sum the figures in the Tonnes column based on filter of "HG" and "LG" in the Stockpile column.
| STOCKPILE | TONNES |
| 503 - HG | 10000 |
| 503 - LG | 15000 |
| 504 - HG | 10000 |
| 504 - LG | 15000 |
| 505 - LG | 15000 |
| 508 - LG | 10000 |
Looking to create the below,
| STOCKPILE | TONNES |
| LG | 55000 |
| HG | 20000 |
You could add a calculated colmn to your table of
Group = RIGHT ( 'Table'[STOCKPILE], 2 )
Then pull that into your visual.
1 Reply
You could add a calculated colmn to your table of
Group = RIGHT ( 'Table'[STOCKPILE], 2 )
Then pull that into your visual.