Forum Discussion

cmfaarvang's avatar
cmfaarvang
Regular Visitor
2 years ago
Solved

Problems with dax count for table with text

Hi,   I am trying to count the total # rows in a table for a specific column (plus another 2 calcs):    adverse_sus_ind_#_rows = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse i...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi cmfaarvang ,

     

    try like:

    measure1 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]=BLANK()))
    measure2 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]<>BLANK()))

FreemanZ's avatar
FreemanZ
Super User
2 years ago

hi cmfaarvang ,

 

try like:

measure1 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]=BLANK()))
measure2 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]<>BLANK()))

cmfaarvang's avatar
cmfaarvang
Regular Visitor
2 years ago

Thanks a lot for that, did not think of that, works great.