Forum Discussion
Count Rows in Visual
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
It works for the Slicers when I just use Location. When I try to add Sales it says "Parameter is not the correct type". But it works like I had wanted, but I forgot to mention that I used a filter for Sales Amount. So the whole idea is to count location where the Sales Amount is less than X amount. So it ignores that when it's counting the rows-it correctly counts only what's selected in the slicer. So any idea on that part?
- Jihwan_Kim
Super User
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
This works amazing! Thank you so much for the PBIX. I was able to implement it.
Thank you. I'll look at the Pbix as soon as I can. I was meaning that let's say there are a 100 rows in table. If I use the slicer to select a filter, it correctly counts the rows e.g. 75 rows. But on the filter pane I have selected to show sales less than x amount. So in the visual it counts 75 rows but should only count 50 rows. I think that's how you have it displayed but just wanted to explain.