Dax expression

[22LACMT]

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))

[PabloDeheza]

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

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

Let me know if that helps!

[22LACMT]

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]

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!

[22LACMT]

The goal is to create a column that only showes rankings that are 11- 15  for a specific asset type.  ex permanent exposure showes x% of the portfolio 11 - 15.  

[PabloDeheza · Accepted solution]

For a column you can do something like:

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