Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table :
Column 1 Column 2 Column 3
Row 1 r1c1 r1c2 r1c3
Row 2 r2c1 r2c2 r2c3
Row 3 r3c1 r3c2 r3c3
I created a measure for each of those columns:
I would like to create another table with the following format:
"Super Column" "Super measure"
Column 1 Measure 1
Column 2 Measure 2
Column 3 Measure 3
Does someone has any idea about how to do this?
Thanks for your help
Solved! Go to Solution.
Hi @Anonymous,
Still not clear on what you need to achieve but in this case the best option is to make an unpivot of the columns and use the new column created in unpivoted as the "legend" in your chart.
However you can make a new table with the following DAX formula:
Table = UNION ( ROW ( "MEASURE"; "MEASURE 1"; "MEASURE VALUE"; [Measure 1] ); ROW ( "MEASURE"; "MEASURE 2"; "MEASURE VALUE"; [Measure 2] ); ROW ( "MEASURE"; "MEASURE 3"; "MEASURE VALUE"; [Measure 3] ) )
Check the following link to see more details on the use of this formula.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsi Have a measure in table A and a column in table B now i want
A measure that calculate
if A.currency = B.currency then(these conditions may be different)
mymeasure = A.measure(sum of price) * B.Exchangerate
How i can achieve this please help!
Hi @Anonymous ,
Check this post where they make the use of an exchange currency table to calculate changes in currency, maybe can be used on you case.
If you need any help adjusting the presented option to your solution please share some sample data.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous,
Whatdo you mean by making a new table witth the measures?Having created the measure you can now used them to make visuals and a table visual that would show your data as you need, not necessary to create another table to your model.
In order to get your question answer better please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix
Thank you for your answer.
Actually, I need to see in a visual the measures together, and not one by one. I could see it one by one with a gauge for instance, but the purpose of my question is that I need to see each measure on the same visual such as we could see on a radar chart, with the column as category and the measures as axis.
Hi @Anonymous,
Still not clear on what you need to achieve but in this case the best option is to make an unpivot of the columns and use the new column created in unpivoted as the "legend" in your chart.
However you can make a new table with the following DAX formula:
Table = UNION ( ROW ( "MEASURE"; "MEASURE 1"; "MEASURE VALUE"; [Measure 1] ); ROW ( "MEASURE"; "MEASURE 2"; "MEASURE VALUE"; [Measure 2] ); ROW ( "MEASURE"; "MEASURE 3"; "MEASURE VALUE"; [Measure 3] ) )
Check the following link to see more details on the use of this formula.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
Thank you a lot! It works perfectly with the global measure!
If I may ask you one last question about this topic, do you think we could link this new table dynamically to the measures? I mean, in order that the changes on the measure, due to filters for instance, appears also in the new table?
Thank you again, it works perfectly with the global measure! 🙂
BR,
Hi @Anonymous,
Actually we cannot link this new table dynamically to the measures here. Maybe we can multi-row card to work around.
Regards,
Frank
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |