Forum Discussion

Lavishnu's avatar
Lavishnu
Frequent Visitor
2 years ago
Solved

Dynamic row count on the visual dependent on field parameter values

Hi All,   I have a Table visual on my dashboard, the columns/fields using a field parameter to select columns dynamically in table visual. The number of rows changes dynamically dependent on user ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lavishnu 

    Please try this:

    First of all, I create a set of sample:

     

    Home > transform data

    If you want to save the original table, right-click the table and click reference:

     

    All select the columns and click the Unpivot Columns.

     

     

    Apply&Close.

    Add a measure:

    Measure 3 = COUNTROWS('Table (2)')

    The result is as follow:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lavishnu's avatar
Lavishnu
Frequent Visitor
2 years ago

I already tried the above solution. Its works for single value selection. If the users selects mutiples values in field parameter its showing overall count.

In my situation any combination users selects need that summary count.

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Lavishnu 

yes i understood what you want to achieve.

however i dont think this is possible for now . 

 

 to be able to do such a thing , you need to be able to summarize dynamically base on the selected columns selected from the field paramter, which i dont think is possible for now ( as far as i know ) .