Need table visual row count using field parameter value selection

[Lavishnu]

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?

[Anonymous · Accepted solution]

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.}