Forum Discussion

22LACMT's avatar
22LACMT
Icon for Helper III rankHelper III
3 years ago
Solved

Dax expression

im trying to filter the pd column to only include data that is >=11 and <=15  

my expression isn't working.  Any ideas what im doing wrong? 

 

CriticizedPD11_15 = (FILTER('percent','percent'[PDGrade] >= 11), FILTER('percent','percent'[PDGrade] >= 15))

 

 

Need Help
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    For a column you can do something like:

    CriticizedPD11_15 =
VAR _PDGrade =
    'percent'[PDGrade]
RETURN
IF(
    _PDGrade >= 199 && _PDGrade <= 205,
    'percent'[YourRanking],
    BLANK()
)

     

5 Replies

  • PabloDeheza's avatar
    PabloDeheza
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi 22LACMT !
    Your filter statement should be like this:

    FILTER(
    'percent',
    'percent'[PDGrade] >= 11
        && 'percent'[PDGrade] >= 15
)

    Let me know if that helps!

    • 22LACMT's avatar
      22LACMT
      Icon for Helper III rankHelper III
      3 years ago

      Thank you for the help. I tryied this : 

      CriticizedPD11_15 = FILTER(
      'percent',
      'percent'[PDGrade] >= 11
      && 'percent'[PDGrade] >= 15
      )             --- this is still throwing errors.  Do you know why? 
      • PabloDeheza's avatar
        PabloDeheza
        Icon for Solution Sage rankSolution Sage
        3 years ago

        What is the requirement exactly? Are you trying to create a measure or a column? Are you trying to filter the table to load less data?
        Let me know so I can help you more efficiently.

        Thanks!