Forum Discussion

devgian's avatar
devgian
Frequent Visitor
3 years ago
Solved

HOW TO TOTAL ROWS EVEN WITH SLICER SELECTED

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.