Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

COUNT ROWS BY MONTH and YEAR base off a filter

Hi All I am tying to calulate the total number of rows by year and month as seen in the firs tabel beow but want to count the SSID rows where the SSIDSUPP_DISRUPTION is over 1200 points for that mon...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Does this work

    Surveyor Measure = IF(ISINSCOPE('SQ Audit Test Data'[SSID]),SELECTEDVALUE('SQ Audit Test Data'[SSID]),distinctcount('SQ Audit Test Data'[SSID])&"")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Ashish

When using the measure it say "Can't Display thetVisual". The Format = Whole Number

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

In the Query Editor, change the data type of the SSID column to Number.