New Measure

[olliehernandez]

Hi everyone!

I've created a new measure to count the number of reports for separate categories, however, it's counting all reports rather than separating out all of the reports and only counting the one column selected.  172 is the total number for all categories, the count I'm looking to create would consist of the data below, totalling 7.   I guess, how can I remove the 165 from the count?  Thank so much!

 

Measure: 

Enviornmental Count = COUNT('Report Parks Incident - Form Responses 2'[Issue Type - Environmental Hazard])

[Greg_Deckler · Accepted solution]

@olliehernandez One way would be to filter out the blank in your visual using a visual level filter. The other way woudl be something like below. If this helps, please vote for my sticker! Banana Pickle Math - Microsoft Fabric Community

Measure = COUNTROWS( FILTER( 'Report Park Incident' - Form Responses2', [Issue - Type - Environmental Hazard] <> BLANK() )