Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there anyway we can get the count of rows that are currently selectd after applying all necessary filters?
One way I can think of is exporting the selection and then counting the rows in Excel. However, I am interested in showing this value along side the table.
How can I achieve this?
Thanks.
Solved! Go to Solution.
Hi @shhafiz,
Try to create a measure using the formula below and check if it works fine.
result= COUNTROWS(ALLSELECTED(TableName))
Best Regards,
Angelia
Hi @shhafiz,
Try to create a measure using the formula below and check if it works fine.
result= COUNTROWS(ALLSELECTED(TableName))
Best Regards,
Angelia
Hi,
Try this calculated field formula
=COUNTROWS(Data)
Replace Data with your Table name.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |