Forum Discussion

New Member

2 years ago

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 c...

Need Help

devesh_gupta

Impactful Individual

2 years ago

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.