Forum Discussion
Need Help with Dynamic Row count Based on Table Visual and Slicers
- 8 months ago
Create a Measure
Nr Rows = COUNTROWS ( YourTable )
This will be dynamic and will feel slicers selections
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- 8 months ago
Hi Pradeep_12 ,
if your visual table is different from yout table you can write a measure as follows:
cnt = var tbl = summarize(your_table , [column1 in visual table] , [column 2 in visual table] ,...)
return
countrows(tbl)
if visual table is the same as your table you just need to write a measure like this:
cnt= countrows(your_table)
If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution ✔️ to help the other members find it more quickly.
Hi Pradeep_12 ,
This is the default behaviour of Power BI.
As suggested by FBergamaschi , create a measure for row count and you're all good.
If you have rowcount and slicer columns from 2 different tables, make sure they are connected via relationships and can filter
When ever you select anything in the slicer,it will filter the visualization created on the page.
if you want to turn it off you can use edit interactions.
Please give kudos or mark it solution once confirmed.
Thanks and Regards,
Praful