Forum Discussion

DavidH's avatar
DavidH
Helper I
7 years ago
Solved

Hopefully a simple answer!!

I have been struggling with arranging or segregating tables based upon values from another table.   I have got a simple example for illustration of my problem.   Table 1 is a main table that is b...
Calculatetable
DAX
Filtering
tables
  • Anonymous's avatar
    Anonymous
    7 years ago

    I'm not sure what you're exactly after... My guess is that you want to create a new table via DAX in the model based on Table1 and Table 2.

     

    To create the new table is rather easy.

     

    Table 3 =
CALCULATETABLE(
	'Table 1',
	TREATAS(
		'Table 2',
		'Table 1'[Code]
	)
)

    Another way is to create a relationship from 'Table 1'[Code] to 'Table 2'[Code] (*:1) and then

    Table 3 =
CALCULATETABLE(
	'Table 1',
	'Table 2'
)

     

    Best

    Darek

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I'm not sure what you're exactly after... My guess is that you want to create a new table via DAX in the model based on Table1 and Table 2.

 

To create the new table is rather easy.

 

Table 3 =
CALCULATETABLE(
	'Table 1',
	TREATAS(
		'Table 2',
		'Table 1'[Code]
	)
)

Another way is to create a relationship from 'Table 1'[Code] to 'Table 2'[Code] (*:1) and then

Table 3 =
CALCULATETABLE(
	'Table 1',
	'Table 2'
)

 

Best

Darek