Adding user selectable status category , and calculating count based on selection

[dcr007]

How to do I modify this on the this visual to add a user selectable status category , and calculating count based on selection 

here StatusCount = CALCULATE(
COUNTA('DC8-TenantsNotLogedIn'[Status])
)

I want to : 

1. remove the remove the status count col 

2. move the Total count below the status count. 

3. Add a user selctable filter option in the menu to choose a array of 'status'

4. Update the status count based on selection made.

Appreciate if you could also point to any documentation on the same .

[v-yalanwu-msft · Accepted solution]

Hi, @dcr007 ;

You could use ISINSCOPE(), as follows:

StatusCount = IF(ISINSCOPE('Table'[User]),MAX('Table'[Staus]),COUNT('Table'[Staus]))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.