DAX sum with a measure and transpose / swap values from column to row

[artur4]

Hello,

I am working on a dashboard and I am creating some measures needed for a final measure that has to be used in a Matrix Visual.

Some of these measures are related to hidden virtual tables as the values do not have to change accordingly to the dynamic filtering. I need two measures to change the Totals of the columns and rows of the final Matrix.

Basically, as mentioned in this post I did, I need to assign a value to a column after applying some RLS and the total of the columns/rows has to be always the total of all the values not filtered.  Concering the colums, I did it and it works; while, for the rows I have a problem. So, I have a measure from an hidden virtual table which is summing the values of a specific column with conditions (and the sum is correct) but the values are saved at the column level. Therefore, when I use this measure to modify the row totals of the final Matrix, it is not considered as it is taken as zero.

Is there a way or function in DAX to transpose the values in the measure after having calculated the sum?

Below a rappresentation of what this measure is showing and what I need to have (red arrows).

Basically, it is like changing the row label with the column label on this matrix but I need to do it in DAX only for this measure because otherwise I'll have the same problem with the column then.

[Anonymous · Accepted solution]

Hi @artur4 ,

You can new an other calculated table using UNION() function.

UNION(<table_expression1>, <table_expression2> [,<table_expression>]…)  

Please refer to the following posts that may be helpful to you:

Transpose with DAX - Microsoft Power BI Community

www.reddit.com

Solved: Transpose Table in DAX - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.