Visual Level Filter issues in displaying records

[Charu]

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?

[Anonymous]

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]

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 

[v-chuncz-msft · Accepted solution]

@Charu,

You may check Show Categories With No Data.