Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
7 years ago
Solved

Data Disappear when Filtered

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.