Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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")
Solved! Go to Solution.
Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI || Device_Type[Type]="DPI)
Is there a reason you need actual physical tables?
can you provide sample data or PBIX file and explain what you need to compute?
Proud to be a Super User!
Paul on Linkedin.
Would the following work:
Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI && Device_Type[Type]="DPI)
Sub 1 = Calculatedtable = ('tablemaster,'tablemaster[Combined_Mole]="Salbut",Device_Type[Type]="MDI || Device_Type[Type]="DPI)
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)
Proud to be a Super User!
Paul on Linkedin.
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...
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |