deldersveld's avatar
deldersveld
Icon for Resident Rockstar rankResident Rockstar
9 years ago

A Glimpse into Michigan's Children in Poverty

I created this report after seeing a list of local youth service organizations published by the Detroit Free Press. It features simple visualizations based on US Census data from 2015. One unique fea...
Economics
Education
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Looks great! What DAX did you use to determine if one or more than one county were selected?

  • deldersveld's avatar
    deldersveld
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    IF(HASONEVALUE('Poverty Data 2015'[County]), ..., ...)

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks, deldersveld! Any chance you might post the full syntax? I am trying to translate years of Excel dev into DAX and I am not clear on how to get the filter context and to pass in a text value. So this hits two needs. Much appreciated!

       

      Scott