Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello guys i have an issue,
i have a calculated table like this where the values are measures in a another table called "Records"
A | B | C |
23 | 43 | 56 |
created using this DAX Expression
SELECTCOLUMNS(
ADDCOLUMNS('Records',
"A", [Measure A],
"B", [Measure B],
"C", [Measure C],
),
"A",[A],
"B", [B],
"C", [C]
)
I want to transpose it so it looks líke this.
Measure | Value |
A | 23 |
B | 43 |
C | 56 |
Or is there a way i can achieve this structure without having to use the DAX Expression above.
Please help.
Thank you
Solved! Go to Solution.
Hi @Anonymous
UNION (
ROW ( "Measure", "A", "Value", [Measure A] ),
ROW ( "Measure", "B", "Value", [Measure B] ),
ROW ( "Measure", "C", "Value", [Measure C] )
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @Anonymous
UNION (
ROW ( "Measure", "A", "Value", [Measure A] ),
ROW ( "Measure", "B", "Value", [Measure B] ),
ROW ( "Measure", "C", "Value", [Measure C] )
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Perfect! This option worked great for me! It's simple and to-the-point! I needed a table of Measure values and this option did the trick! The table I needed looked this:
<code>
It's perfect and just what I needed! Thank you!
Oh My God, Thank you,
This worked like a dream.
I am so embarassed at how easy the solution was.
Again Thank you.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |