Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show records with missing data

Hello,   I have an interesting issue that I couldnt find the answer for directly on the forums. Apologies if it has been answered in the past and I've missed it.   I have a simple table as below:...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit,

 

Thanks for the prompt reply as always. I've tried what you've suggested and created a table that has: DistinctCountPersonID+0, Date, Check

 

I then used check in a slicer. However, instead of displaying all results with 0's in the date and check for missing checks on that ID, it only shows me the IDs with the check. In my original example, if I used this method and filtered for 'Check 4', I would only see PersonID 1 & 2 where as PersonID 3 & 4 should still show but with 0 or null values in Date/Check.

 

Apologies if I've misunderstood your suggestion!

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Please refer to my .pbix file.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.