How to filter on a card - works in table view

[Anonymous]

Hi experts,

I think this is a very basic problem. I hope you can help me.

I have been able to filter and get the number i want (31027) in the "table" vizualisation (bottom of the picture).

The filter does not work in a card (seen on the top of the picture)

The filter i need on the card is the distinct count of all the app id's who has more than 5 sessions.

See the picture below:

I am almost certain, that it has something to do with the distinctcount measure not being able to filter the way i want. I have tried to calculate with a filter, but it is not working out for me.

Any ideas?

Thank you very much 🙂

[Ashish_Mathur · Accepted solution]

Hi

Try this measure and drag it to your visuals

=COUNTROWS(FILTER(SUMMARIZE(VALUES('qs v_FactUsage[AppId]),[AppId],"ABCD",[Uniquesessions's]),[ABCD]>5)

Hope this helps.