Count the number of rows selected in a table visual

[DesaulnM]

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.

[some_bih · Accepted solution]

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.

[DesaulnM]

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

[some_bih]

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.

[DesaulnM]

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.

[donfawcett]

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