Forum Discussion

Lavishnu's avatar
Lavishnu
Frequent Visitor
2 years ago
Solved

Need table visual row count using field parameter value selection

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 c...
  • 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.