Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hi5jimmy
New Member

Rowcount with Field Parameter

Hi Power BI Experts,

I am currently using below formula to count the row in table visual which is working fine. However, I want to use filed parameter to select columns dynamically in table visual could you help me how can I transform below formula. Result should display the rowcount no metter what combination user select in field parameter slicer. 

 

Table 1:

Column 1Column 2Column 3Column 4 (used for measure)
    

 

Measure 1 = Sum(Column 4)

 

Formula to calculate rowcount:

COUNTROWS(GROUPBY(Table 1, Table 1 [Column 1], Table 1 [Column 2], Table 1 [Column 3], "Name", sumx(currentgroup(), Table 1 [Measure 1])))

 

Thanks in advance.

5 REPLIES 5
devesh_gupta
Super User
Super User

@hi5jimmy Try if this measure works for you:

RowCountMeasure =
VAR SelectedColumns =
    VALUES('FieldParameterSlicer'[SelectedColumn])
VAR GroupedTable =
    SUMMARIZE(
        'Table 1',
        SelectedColumns,
        "RowCount", COUNTROWS('Table 1')
    )
RETURN
    COUNTROWS(GroupedTable)

 

If you find this insightful, please provide a Kudo and accept this as a solution.

Hi @devesh_gupta ,

This is resulting in total rowcount of table as below step gives all columns not selected ones.

VALUES('FieldParameterSlicer'[SelectedColumn])

 

Hi @devesh_gupta ,

Thanks for your inputs. however, Summarize function is not allowing me to use parameters in second argument. It says Summarize function expects a column name as argument number 2.

@hi5jimmy Okay, let's try like this:

 

RowCountMeasure =
VAR SelectedColumns =
    VALUES('FieldParameterSlicer'[SelectedColumn])
VAR GroupedTable =
    CALCULATETABLE(
        'Table 1',
        'FieldParameterSlicer',
        'FieldParameterSlicer'[SelectedColumn] IN SelectedColumns
    )
RETURN
    COUNTROWS(GroupedTable)

 

If you find this insightful, please provide a Kudo and accept this as a solution.

Hi Devesh

 

Getting error !!

Lavishnu_0-1707532456859.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.