topic Re: Count the number of rows selected in a table visual in DAX Commands and Tips

Count the number of rows selected in a table visual

DesaulnM — Fri, 18 Aug 2023 15:18:13 GMT

Hi,

I have a table visual that is used to filter two other visuals. I would like the two other visuals to show data only when a single row is selected from the main table. I tried using DISTINCTCOUNT but it returns the total number of rows and not only the ones selected. I also tried SELECTEDVALUE and ISFILTERED but it returns BLANK and FALSE whatever is selected in the table.

I don't want to use a slicer because I need to let the users sort the table by the column of their choice to find the application for which they want to see the details which is not possible with a slicer.

Any idea how I can achieve this? Thanks.

Re: Count the number of rows selected in a table visual

some_bih — Sun, 20 Aug 2023 10:58:58 GMT

Hi DesaulnM to count rows simple use COUNTROWS

COUNTROWS([<table>])

[<table>] replace where your Application ID column is located. Put this measure into card visual.

Did I answer correctly? Kudos appreciate / accept solution.

Re: Count the number of rows selected in a table visual

DesaulnM — Mon, 21 Aug 2023 13:33:19 GMT

Unfortunately, the count stays the same when I select a row in the table visual. I would like the count to be 1 when only 1 row is selected. I guess it's not possible to count the rows selected directly in the table visual.

Re: Count the number of rows selected in a table visual

some_bih — Mon, 21 Aug 2023 14:23:23 GMT

Hi DesaulnM "it depends" what is your canvas interaction. Usually, it in table you have Application ID and select some of them, in other visual on same canvas this measure should be recalculated in manner to count number of rows in that table.

Re: Count the number of rows selected in a table visual

DesaulnM — Mon, 21 Aug 2023 20:05:30 GMT

For those interested, I was able to do it with a calculated table.

Re: Count the number of rows selected in a table visual

donfawcett — Mon, 09 Dec 2024 18:18:00 GMT

Hi Desauln - I have the exact same problem I am trying to work out. Did you ever find a solution?