Forum Discussion
Solved
Count Rows in Visual
I want to count rows in a Matrix visual. The row count would change based on what is selected in the slicers. I want to put the count in a card that will change dynamically based on what is select...
Hi,
I am not sure if I understood your question correctly, but I think we can try using numeric parameter something like below. Please check the below picture and the attached pbix file.
Or, please share your sample pbix file's link to help me to have a bit more clear understanding.Use parameters to visualize variables - Power BI | Microsoft Learn
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
In the measure, I used COUNTROWS DAX function.
COUNTROWS function (DAX) - DAX | Microsoft Learn
Location count: =
VAR _t =
SUMMARIZE (
sales,
location[location]
)
RETURN
COUNTROWS ( _t )