Combining data in rows

[Filippomonti]

Hi all,

I have this kind of dataset:

Table 1:

Name  |  Number

A         |       1

B         |       2

C         |       3

D         |       4

table 2: 

Name  |  Number

Aa         |       1.1

Ab         |       1.2

Bb         |       2.1

Bc         |       2.2

Cc         |       3.1

Cd         |       3.2

Dd         |       4.1

De         |       4.2

I want to create a measure that return this kind of structure in my matrix:

Name | Number

A        |      1

   Aa   |     1.1

   Ab   |     1.2

B        |      2

   Bb   |     2.1

   Bc   |     2.2

And so on. Can anyone help me please?

Thanks!

[Anonymous]

Hi @Filippomonti ,

 I figured out how to solve the problem with a "IF(ISINSCOPE....)) measure

Glad to know your issue has been solved by yourself and thanks for your feedback😀

Please Accept your reply as the solution to make the thread closed. More people will benefit from it. 

Best Regards,
Eyelyn Qin

[Filippomonti]

Hi Eyelyn,

I'm really sorry, i didn't know I had to do that. Hope this is all good now.

Thanks for your help!

Best regards

Filippo

[Filippomonti]

Table 1:

MACROName  |  MACRONumber

A         |       1

B         |       2

C         |       3

D         |       4

table 2: 

MICROName  |  MICRONumber

Aa         |       1.1

Ab         |       1.2

Bb         |       2.1

Bc         |       2.2

Cc         |       3.1

Cd         |       3.2

Dd         |       4.1

De         |       4.2

I want to create a measure that return this kind of structure in my matrix:

Name | Number (MACRO THEN MICRO)

A        |      1

   Aa   |     1.1

   Ab   |     1.2

B        |      2

   Bb   |     2.1

   Bc   |     2.2

I try to explain better with ore informations

[Filippomonti]

Hi Ryan, 

thanks for the reply.

The problem is that i want to keep the 2 tables divided because there are other datas that i didn't include in the previous example (that was a semplified version).

That said, I'm trying to create a measure that helps me visualize the numbers so I can create an index like measure to sort the matrix.

Hope this helps a little bit.

[ryan_mayu]

@Filippomonti 

do you mean there is no relationship between two tables?

I didn't combine the tables. I just created a new column in table 2.

Could you pls provide more sample data so that I can provide better solution for you?

[Filippomonti · Accepted solution]

Thanks for your reply, I figured out how to solve the problem with a "IF(ISINSCOPE....)) measure

[ryan_mayu]

@Filippomonti 

based on your sample data, maybe I will use LEFT function to create a new Name column and create relationship between Name column in table A and New name column in table B.