DAX function

[DanduMani104]

Hi all,I just Append Two tables . I required a DAX Function To show the data Saparetely as Parent Tables when we Apply Slicer.

Can you people please help which DAX expression uses this problem.

e.g : In slicer If I select table 1,It has to show the only table 1 Data,If I select Table 2,It has to show Only Table 2 Data...Like that

[DanduMani104]

Yup...But How can we romove Blank rows in Appended table

[eliasayyy]

what do you mean can you hsow me?

[DanduMani104]

Ok.. For example we created custom colomns for both the tables.. And append the tables.. Table one data comes first along with custom column.. And table 2 data comes first along with custom colomns... And null values arrived for table 1 data in table 2 custom column... How can we remove those.... 

[eliasayyy]

can you show me a picture please? 

you need to add the same column name so they append under each otehrs

name the custom column "Table" for both tables 

once you name the table you need to fill in values,

for table one write "Table 1" for table two write "Table 2" 

[eliasayyy]

before appending create a new column for each table called table

name the first one "Table 1" and the second "Table 2" then append them 

and now use the new custom column "Table" as your slicer