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 - ...
You could add a calculated colmn to your table of
Group = RIGHT ( 'Table'[STOCKPILE], 2 )
Then pull that into your visual.
You could add a calculated colmn to your table of
Group = RIGHT ( 'Table'[STOCKPILE], 2 )
Then pull that into your visual.