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 ,
This is resulting in total rowcount of table as below step gives all columns not selected ones.
VALUES('FieldParameterSlicer'[SelectedColumn])