Forum Discussion
Julier
Helper III
Helper IIIsum multiple columns
I have three columns with the sames machine in some of the other columns and i have a column showing the sqm how can i show the value for each machine in one one column, for example combine all of th...
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!
Hi Julier ,
If you don't want to change the schema of the table, try creating a table for the slicer like this:
Relationship:
And then please create a new measure:
Total SQM =
VAR __selected_value = SELECTEDVALUE('DimConversionMachine'[ConversionMachine])
VAR __result =
SUMX(
FILTER( ALL('Table'),
'Table'[First Conversion Machine Description]=__selected_value
|| 'Table'[Second Conversion Machine Description]=__selected_value
|| 'Table'[Third Conversion Machine Description]=__selected_value
),
'Table'[SQM]
)
RETURN
__result
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum