Forum Discussion

Pandadev's avatar
Pandadev
Post Prodigy
6 years ago

Add a filter to a summarised table

I have created a summarised table , using count of rows. but I need to have this updated to get the count of rows based on a slicer selection. each table is linked via a relationship. and all tables on their own pages are updated. but the summarised table is not. the table where the filter is located is res list and the column name is res. Here is my current code

I have built a summary table using this code

union(
summarize('QC Check 1', "Table","QC Check 1", "Rows",countrows('QC Check 1')),
summarize('QC Check 2', "Table","QC Check 2", "Rows",countrows('QC Check 2')),
summarize('QC Check 3', "Table","QC Check 3", "Rows",countrows('QC Check 3')) // so on
)
Need Help

4 Replies

    • Pandadev's avatar
      Pandadev
      Post Prodigy
      6 years ago

      Thanks , is there another solution that could work , where I can get a count of rows of each table , based on a slicer filter

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        6 years ago

        Hi Pandadev 

        when creating a "new table", it is impossible to make the result of  "count" function to change based on slicers.

        You could create measures and use measures in table visuals.

        Please share some examples so i can reproduce your problem.

         

        Best Regards

        Maggie