Combining data in rows

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.

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.

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

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