Forum Discussion
Problems with Merge Queries
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] ) ) ) )
parry2k thanks, I could use the relationship model but there is a significant inconvenience:
When two columns are put together in a table visual, which columns come from different tables that have been joined, there are fields that have no value because there the joining of the tables is not complete.
These empty values (which appear after you choose 'Show no values' in the table visual), cannot be included in the slicers. So whatever you choose in the slicers, the empty values will always be present which is inconvenient.
That's why I was thinking to do a Merge Query and replace the empty values with null in the column so that they can be filtered in the table visual using slicers.
Is there a solution for this?
Anonymous I think I got the gist of your problem, why not share sample data and what you are trying to achieve and let's what we can do here.
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.
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] ) ) ) )