Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problems with Merge Queries

Hello   I am using Merge Queries and I have the problems below:   1) The calculated columns do not appear in the list of columns to expand when I join a table, why is this happening? Can I not ex...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

     

    If you want to show blank and A in slicer, you need to create a new table. I create a sample. Please have a try.

    Table =
ADDCOLUMNS (
    VALUES ( Table2[Column1] ),
    "Table1_Column2", CALCULATE (
        MAX ( Table1[Column2] ),
        FILTER ( Table1, Table1[Column1] IN VALUES ( Table2[Column1] ) )
    )
)

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k please find here: https://ufile.io/9gmho4r8 

 

I want the slicer to filter the empty values only but it does not have that option.

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

 

If you want to show blank and A in slicer, you need to create a new table. I create a sample. Please have a try.

Table =
ADDCOLUMNS (
    VALUES ( Table2[Column1] ),
    "Table1_Column2", CALCULATE (
        MAX ( Table1[Column2] ),
        FILTER ( Table1, Table1[Column1] IN VALUES ( Table2[Column1] ) )
    )
)