Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
For those interested, I was able to do it with a calculated table.
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.
Proud to be a Super User!
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.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |