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

[Anonymous]

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

[Anonymous]

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!

---

[MFelix]

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

[MFelix]

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

[Anonymous]

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.

[MFelix · 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

[Anonymous]

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,

[v-frfei-msft]

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