Count of rows for table visual based on condition and filters

[Anonymous]

Hey,

I have a visual table in PowerBI that looks something like this but with more data:

I want to count the number of rows for each company where Prime or Not Prime = "Prime"

I want this count measure to work with slicers/filters that will be added to the page e.g., If I select "Company A" in the slicer then the KPI for Prime should show a count of 1.

Thanks!

[V-pazhen-msft · Accepted solution]

@Anonymous 

Create a measure, then add the supplier column and the measure in a table visual.

measure = Calculate(count([supplier], filter(Table,Table[Prime or Not Prime] = "Prime"))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try a measure like

countrows(filter(Table,Table[Prime or Not Prime] = "Prime"))