How to remove a filter and get a count

asbpowerbi — Fri, 15 Sep 2023 18:24:19 GMT

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

Re: How to remove a filter and get a count

Anonymous — Mon, 18 Sep 2023 05:39:21 GMT

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.

topic How to remove a filter and get a count in Developer

How to remove a filter and get a count

Re: How to remove a filter and get a count