Count of a table values sum

[Anonymous]

Hi All

I am trying to get the count sum of the SSID to show up in the SSID Count. So for the second table below, for the month of Jan , I want the SSID Count to be = 2, Thanks for any help

[Anonymous]

Ashish

I was to figure it out

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Try

Calculate(distinctcount('table'[ssid]),filter(all('table'),'table'[month]=selectedvalue('table'[month])))

If I misunderstand your meaning, please share some sample data.

Best Regards,

Jay

[Ashish_Mathur]

Hi,

Some variant of this measure will help:

=countrows(filter(values(data[SSID]),[Values]>0))

Values is a measure which returns 1325 and 1400 in visual 1.

[Anonymous]

Thanks Ashish

I was trying to get the value 2 as a sum using the following measure but will not take.

CountSSID = countrows(filter(values('SQ Audit Test Data'[SSID]]),('SQ Audit Test Data'[SUPP_DISRUPTION]>1200)))

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.