Visualize the missing data

[Anonymous]

Hi, I have a dataset as below:

Table 1 Dataset :::::::: On date 1, I have 10 data and on 2nd 15 data and on 3rd 26 data.

Table 2 Dataset :::::::: I have 26 data. Only data I have, no Date.

Count of Table 1 is distinct count.

When I click on Date 1, the data will become like:

Now I want to show the Missing 16 Data when i click Date 1.

If I click Date 2, it should show the missing 11 Data.

And nothing to show if when i click Date 3 as all Data is present in Date 3.

Any heads up will help me much!! Thanks!

[Ashish_Mathur]

Hi,

This should be possible in the Query Editor.  Share the raw data in a format that can be pasted in an Excel file.

[Nathaniel_C]

@Anonymous ,

Here you go: Did a LOOKUPVALUE() using the other table column as both the column to peruse and the column to return matched against the shorter column. and added a if statement that return the ones that are not there.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

look = If(LOOKUPVALUE(qw[Column1],qw[Column1],ol[Column1]),BLANK(),ol[Column1])

[Nathaniel_C]

@Anonymous ,

Try EXCEPT () https://docs.microsoft.com/en-us/dax/except-function-dax

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

Except () will work only if the number of columns of both tables are same. Is there any other way to acheive this?