Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Create a dynamic table with column of many measures done on different columns from previous table

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: 

  • For column 1 : "Measure 1"
  • For column 2 : "Measure 2"
  • For column 3 : "Measure 3"

 

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

1 ACCEPTED 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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

7 REPLIES 7
Anonymous
Not applicable

i 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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix
Super User
Super User

Hi @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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Hi @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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Hi @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.

 

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.