Count is not filter

[Chanleakna123]

Hi Everyone , 

I can't filter with CARD , when i click the Donut Table on Available-C , the Card didn't count the number in Available-C , 
I tried to random the same questions in community as well as using the same DAX calculation here but the output is still not filtered , 

any idea how to solve this ? 

[v-jiascu-msft]

Hi @Chanleakna123,

It works fine in my test. What's the formula of the value you used in the CARD? Could you please provide the pbix file? Please mask the confidential info first.

You still can check the formula if it contains the functions like ALL(), ALLSELECETED(), which will ignore the filter of its parameter.

Best Regards,

Dale

[Chanleakna123]

@v-jiascu-msft ,

hi , when i click on Donut , Available , on the table shown 2 Materials Description which is available. But the Card keep showing the overall total of Class C only , Do you have any solution on this ? 

Thanks with Regards, 
Chanleakna Hang 

[v-jiascu-msft]

Hi Chanleakna,

What is the formula you use in the field of Card?

Best Regards,

Dale

[Chanleakna123]

@v-jiascu-msft I used Count Format in BI Fields. 

Thx

[v-jiascu-msft]

As we can see from your first post, there is a slicer that filters the Class to "C" only. Is this the cause? If not, please provide the dummy pbix file. Mask the confidential info fist.

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Chanleakna123,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale