Data Disappear when Filtered

[ovetteabejuela]

Okay first, here the unfiltered table, notice that there are entries with complete data Feb 01 through 28) and there are those with completely blank or partially blank.

Here's how the Relationships look like (absically just 1 is to 1, basic 1 table is dimension and the other is data,.
\

Basically I need to create a filter that will show all complete/incomplete entries and here's what I did:

Category= SWITCH(
    TRUE(),
    CALCULATE(COUNTROWS(DimTable),ISBLANK('DataTable'[TotalColumn]))>0,"Incomplete",
    CALCULATE(COUNTROWS(DimTable),ISBLANK('DataTable'[TotalColumn]))=0,"Complete")

The "Complete" filter seem to work accordingly but when I do the "Incomplete" filter, those days with some data were lost: This is what it looks like:

 (sorry i can't seem to paste more image but i think you get it... I am, expecting all entries with no data at all to appear and those entries with incomplete data submitted, unfortunately not working for now.

[v-chuncz-msft · Accepted solution]

@ovetteabejuela,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846