Forum Discussion
Dynamic row count on the visual dependent on field parameter values
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.
ok i got you, you are asking about the dax measure to write to get the count 😅
mmm, i think you need to create a measure that is counting the rows for each combination :
example let us say we have in the field paramter , customer and product .
so i need 3 measures :
count when product is selected alone ,
count when customer is selected alone
and count when both are seleced .
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
Example:
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
im afraid there is no other way for now that im aware of .
found this link, could be helful
If this answers your question , mark it as the solution ✅ so can you can help other people in the community find it easily .
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.
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 ) .
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.