Forum Discussion
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 choices, and the user can pick any combination of values in field parameters.
Example:
In my scenario i have 20 columns the user can pick max 5 combination of values in field parameters.
Columns: Customers, Products, Category, Units, Levels, InStock etc
If Count when products selected alone
If Counts when products & customer where selected
If counts any columns selected where need summary count which ever values selected
Need a row count in Card Visual. How many rows appear in the table visual dependent on field parameter selection?
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.
1 Reply
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.