Forum Discussion
Summarize table and grouping values by multiple conditions in one column
Hello, Please can someone help me with my calculation. I have a dataset which looks like the below, I cannot change the structure of the data. I need to create a calculation which will multip...
Anonymous
You can add an additional measure as follows this will work based on the selected UOM,UOM = IF( SELECTEDVALUE( Table7[UnitOfMeasure] ) = "Recycled" , [UnitOfMeasure(Recycled)] , [UnitOfMeasure(Reused)] )You can add this to your chart
Fowmy
Super User
Super UserAnonymous
You can add an additional measure as follows this will work based on the selected UOM,
UOM = IF( SELECTEDVALUE( Table7[UnitOfMeasure] ) = "Recycled" , [UnitOfMeasure(Recycled)] , [UnitOfMeasure(Reused)] ) You can add this to your chart
Smashed it - thank you! 🙂