Forum Discussion

Charu's avatar
Charu
Post Patron
8 years ago
Solved

Visual Level Filter issues in displaying records

Hi 

I have applied the filter condition like 

count = CALCULATE (
COUNT( BF_DATA[DIST_ITEM_AMOUNT] ),
FILTER ( BF_DATA, BF_DATA[INT_STATE_TAX] = 0 || BF_DATA[INT_STATE_TAX] = BLANK()))

 

 

 

 

The query returns 3Records but in visual it shows only 2 records.

 

Can anyone help me resolve it?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Charu,

     

    I see you also use a time slicer, are you sure you did'nt filter the third record out with a different slicer or filter ?

     

    Regards,

    L.Meijdam

    • Charu's avatar
      Charu
      Post Patron
      8 years ago

      Hi Anonymous

       

      I'm not filtering with the date here.I'm using the advanced filter condition which is as below


       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      I'm getting count as why because In Table 3 records there

      But in visual It is not displaying the 3rd record.

       

      I have tested by changing the condition value its working fine but for the condition "is zero " it is not working as expected