Forum Discussion

asbpowerbi's avatar
asbpowerbi
Helper IV
2 years ago
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 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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.