Forum Discussion
Solved
How to remove a filter and get a count
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 t...
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.
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.