Sum multiple columns values based on filter

Hi,

to obtain something like this

the easiest solution is to unpivot column in performance table 
- select your SolutionID columns and then unpivot

- rename the column you obtain conveniently and load.

You can obtain the same thing in DAX by creating a new table

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

thank you that's really help, is there anyway I could apply a workload filter on this too?

You have only to create a relationship between your two table

then add Workload as a slicer and now you can slice and dice as you want

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !