Combine - Two Calcualate tables into one Table

[Anonymous]

Hi Experts

how could i modify the following DAX to combine the two seperate Calculated Tables into one master table

Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI")

Sub 2 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="DPI")

[PaulDBrown]

Is there a reason you need actual physical tables?

can you provide sample data or PBIX file and explain what you need to compute?

[Anonymous]

Would the following work: 
Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI && Device_Type[Type]="DPI)

[Anonymous · Accepted solution]

Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI || Device_Type[Type]="DPI)

[PaulDBrown]

You can try:

New Table = 

VAR Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI")

VAR Sub 2 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="DPI")

RETURN
UNION(Sub 1, Sub 2)

[Anonymous]

Hi Paul - currently the two calculatetables are giving me two seperate table one showing MDI info and the other showinf DPI info....the columns in both table are the same less the device type. i just want one table to show both MDI & DPI in one calculated table...