Forum Discussion

alhowarth's avatar
alhowarth
Icon for Helper I rankHelper I
6 years ago
Solved

DAX help please

I would like to create the DAX equivalent of this:   SELECT COUNT(JOB_NAME) JOB_COUNT FROM MYDB.dbo.MY_TABLE WHERE JOB_TYPE <> '98' AND BOX_NAME <> ''   I can get the count using this:  JOB_CO...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    alhowarth , Try like

    calculate(count(MY_TABLE[JOB_NAME]), filter(MY_TABLE, MY_TABLE[JOB_TYPE] ="98" && not(isblank(MY_TABLE[BOX_NAME])) ))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

alhowarth , Try like

calculate(count(MY_TABLE[JOB_NAME]), filter(MY_TABLE, MY_TABLE[JOB_TYPE] ="98" && not(isblank(MY_TABLE[BOX_NAME])) ))