How to remove a filter and get a count

[asbpowerbi]

Hello Community,

I am a new user. I have an embeded power BI report. When displying the report we also send a value to filter (CustomerEmailAddress)  our Tickets (st_Tickets) table so that when the report displays, it only displays the data for the sent filter value. This works fine and I am able to display a count of the filterd users tickets. 

I now have been asked to display the total number of tickets in the table. I know I need to create a measure, but I can not figure out how to remove the filter. The table is st_Tickets and I do a count of Ticket_ID to get the ticket count. The filter is on the CustomerEmailAddress column in the same table. Here is what I have tried when creating a measure:

TotalTickets = CountRows(calculate('st_tickets', removefilters())) ----and different varaitions of this.

Any help or guidence would be apprecaited!

Peter

[v-rzhou-msft · Accepted solution]

Hi @asbpowerbi ,

I think you can try ALL() function to remove filters.

TotalTickets =
CALCULATE ( COUNTROWS ( 'st_tickets' ), ALL ( 'st_tickets' ) )

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.