Forum Discussion
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'[PDGr...
For a column you can do something like:
CriticizedPD11_15 = VAR _PDGrade = 'percent'[PDGrade] RETURN IF( _PDGrade >= 199 && _PDGrade <= 205, 'percent'[YourRanking], BLANK() )
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!
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.