Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Total_Request = COUNTROWS(ALL(tbl_portfolio_request))
Total_Request = COUNTROWS(ALL(tbl_portfolio_request))
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |