In Power Bi how to create a measure giving Number of Rows in a Table Visual

Question

I want to set a visual in Power Bi and want to get row count which adjusted as user and want to set filters and use slicers,The column doesnt have one level of hierarchy and I want to see the count of rows in the table

How can I do it?

Answer 1

Use the following calculated feild

CountSummaryRows = 
CALCULATE(
    COUNTROWS(SUMMARIZE(Table1, Table1[A], Table1[B], Table1[C], Table1[D])), 
    ALL(Table1)
    )

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification