Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |