Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
For a column you can do something like:
CriticizedPD11_15 =
VAR _PDGrade =
'percent'[PDGrade]
RETURN
IF(
_PDGrade >= 199 && _PDGrade <= 205,
'percent'[YourRanking],
BLANK()
)
Hi @22LACMT !
Your filter statement should be like this:
FILTER(
'percent',
'percent'[PDGrade] >= 11
&& 'percent'[PDGrade] >= 15
)
Let me know if that helps!
Thank you for the help. I tryied this :
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.
For a column you can do something like:
CriticizedPD11_15 =
VAR _PDGrade =
'percent'[PDGrade]
RETURN
IF(
_PDGrade >= 199 && _PDGrade <= 205,
'percent'[YourRanking],
BLANK()
)
User | Count |
---|---|
87 | |
84 | |
70 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |