Solved: Grouping figures using Filter on another column

dwyermf · ‎09-20-2019

Looking to create a measure to sum the figures in the Tonnes column based on filter of "HG" and "LG" in the Stockpile column.

Looking to create the below,

jdbuchanan71 · ‎09-20-2019

You could add a calculated colmn to your table of

Group = RIGHT ( 'Table'[STOCKPILE], 2 )

Then pull that into your visual.

jdbuchanan71 · ‎09-20-2019

You could add a calculated colmn to your table of

Group = RIGHT ( 'Table'[STOCKPILE], 2 )

Then pull that into your visual.

Grouping figures using Filter on another column