Forum Discussion

hi5jimmy's avatar
hi5jimmy
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
hi5jimmy's avatar
hi5jimmy
New Member
2 years ago

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.

devesh_gupta's avatar
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.

  • Lavishnu's avatar
    Lavishnu
    Frequent Visitor
    2 years ago

    Hi Devesh

     

    Getting error !!