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.
You don’t need anything fancy for this.
Row Count =
COUNTROWS ( FactTable )
If the table can show rows from different tables or via a field parameter, use ALLSELECTED on the main table behind the visual:
Row Count =
COUNTROWS (
ALLSELECTED ( FactTable )
)
Put that in a Card, align it above the table, and you’re done.
If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande