Card Visual that shows info based on multiple conditions?

[Gerbil]

So I have a table like so:

Region	Name	On/Off	Count
North	John	On	12
South	Drake	Off	11
South	Jason	On	5

The count column is counting how many instances of the region/name/onoff combo there is. So there are 12 entries with region North, name John, and condition On. I want a card that shows the number of entries that are "Off" and have a count higher than 10. How would I go about doing that?

So the preferred outcome would be a card displaying 1 since there is one row that fits those criteria.

[Arul]

@Gerbil ,

try this measure,

Off count = COUNTROWS(FILTER('Table',SUM('Table'[Count])>10 && 'Table'[On/Off] = "Off"))

[Gerbil]

So I can't do a sum of the Count column because it is counting entries, not really a number. I tried using that measure with COUNT instead of SUM but it is just counting all the entries with on/off column = off.

[Arul]

@Gerbil ,

Well that could be a datatype issue. I assume count column is whole number type, it worked.

[Gerbil]

The column Count is actually the job ID, which is a text type. The table was created through Power BI by selecting "Region", "Name", "On/Off", then the count of "Count" (job ID). I'm not sure how to create a column that shows the count with those conditions since it needs to be dynamic and job entries will change daily.

[Arul]

@Gerbil ,

Change the datatype of the column named "Count" in Power Query Editor. Click on Abc besides the column and in the dropdown change the datatype to whole number.

it will be changed like this,

[Gerbil]

The "Count" column is a job ID, which is a mix of alpha and numeric values. So I can't change that to a whole number column.

But I created a new column, calling it "JobCounter", and set the value as 1 for each entry. Still, it did not work and the card is showing the number of jobs with the condition "Off". It is not showing me the number of Region/Name combo with the condition "Off" that have more than 10 count.

[Arul]

@Gerbil ,

Is it possible to share the file?