Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to create a new table that will allow me to combine measure values into 2 columns, Measure Name, and Measure Value.
I am have calculated seperate measures for some of my key attributes; Uniqueness, Timeliness, Completness etc at an attribute level (e.g. Account ID, Customer Name etc).
I'd like to show this at a team level, usng a Radar chart.
To do this, I need the seperate measure values in 2 columns Category and Y-Axis which is the data field.
Can anyone help me shape my data to get it into this format? I could pivot the data if it was columns, but can't seem to as measures.
Thanks
anish
@dosania
I doubt this is possible, measures is not a value store, you cannot just have it in a table by it self. And there is no way to get the names in a column list.
Maybe share a sample table, and also the table visual including a few measures. Let's see if there is any other workaround.
Paul Zheng _ Community Support Team
@dosania , You can add the measure to the table, but that will not respond to slicer filters
You can create like
Addcolumns(summarize(Table, Table[Col], Table[Col]), "M1", [Measure1])
Thanks @amitchandak . I've tried using your suggestion, and have written the following;
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |