Forum Discussion
Calculating multiple column values using a row value
See there're 2 tables Table 1 & Table 2. I need to get the sum for row values of table 1 from columns of table 2.
Anonymous
I would still advise you to re-organize your data as you have a large amount. You have it done at the source level. You can request your data source owner to do it for you.
Doing it dax is painful and will cause memory and performance issues:
However, You can try this approach with DAX with UNION and SELECTCOLUMNS : https://stackoverflow.com/questions/50213905/is-it-possible-to-unpivot-in-power-bi-using-dax
I have managed to do so using if sum & calculate but the result is constant and would not change as per any applied slicer but thanks a lot for reaching out (Y)