Forum Discussion
Helper IIIsum multiple columns
Hi Julier
- Unpivot Columns: Go to Power Query, select the three machine columns, right-click, and Unpivot Columns, or alternatively select the SQM and Unpivot other Columns.
- Rename the new value column to Machine Description.
- Group By: Use Group By on Machine Description to sum SQM.
- Analyze the data: For instance, create a slicer and use the Machine Description to filter the data by machine and show total SQM.
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedInWorked like a dream thank you!
Super UserHello Julier ,
You can use slicer each text columns and then select the value in the slicers with using hiearchy from 3 columns. ฤฐf you don't want to use slicer and give the values only you specify that you need to write measure.
For example you want to calculate only for master cut.
measuretest=
CALCULATE(SUM(table[SQM]),FILTER(table, table[secondmachinedesc] = "Master Cut"))
But if you'd like toRemoves context filters from columns and rows in the current query, while retaining all other context filters or explicit filters. you can use in the measre ALLSELECTED too.
Kind Regards,
Gรถkberk Uzuntaล
๐ If this post helps, then please consider Accepting it as a solution and giving Kudos โ it helps other members find answers faster!
๐ Stay Connected:
๐ Medium |
๐บ YouTube |
๐ผ LinkedIn |
๐ท Instagram |
๐ฆ X |
๐ฝ Reddit |
๐ Website |
๐ต TikTok |