HOW TO TOTAL ROWS EVEN WITH SLICER SELECTED

[devgian]

Hello Everyone, 

Good day! 

I'm new to PBI and I need your help. I have created a measure to Count the Total Rows of all request.

But what I want to achieve is, whenever I select any of the status of the request, I want the total of request should always be the exact number of rows in the table.

This is the total number of rows: 

When select any status it counts the current selected status.

I want it to remain 17.

This is only formula i used.

Total_Request = COUNTROWS(tbl_portfolio_request) 

Thanks in advance for your help.

[Greg_Deckler · Accepted solution]

@devgian 

Total_Request = COUNTROWS(ALL(tbl_portfolio_request)) 

[devgian]

Thanks @Greg_Deckler