Forum Discussion
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...
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 ,
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 !!
