Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
As per the title why does 'path B' work and the commented out segment of code 'path A' does not?
EVALUATE
VAR ProgressList_Target =
FILTER (
SELECTCOLUMNS (
'Measure Benefit Progress List',
"MeasureID" , 'Measure Benefit Progress List'[Main ID LkUpId]+0,
"Financial Year" , 'Measure Benefit Progress list'[Financial Year],
"Target" , 'Measure Benefit Progress list'[Revised] -- value for 2027
),
---'Measure Benefit Progress list'[Financial Year] = "2026-27" -- path A
PATHCONTAINS ( "2026-27", [Financial Year] ) -- path B
)
RETURN
ProgressList_Target
How to make 'path A' work? The https://dax.guide/filter/ guide example uses the exact same construct.
EVALUATE
FILTER (
Customer,
Customer[Continent] = "Europe"
)
Solved! Go to Solution.
Please try it this way
EVALUATE
VAR ProgressList_Target =
FILTER (
SELECTCOLUMNS (
'Measure Benefit Progress List',
"MeasureID", 'Measure Benefit Progress List'[Main ID LkUpId] + 0,
"@FinancialYear", 'Measure Benefit Progress list'[Financial Year],
"Target", 'Measure Benefit Progress list'[Revised]
),
[@FinancialYear] = "2026-27"
)
RETURN
ProgressList_Target
Please try it this way
EVALUATE
VAR ProgressList_Target =
FILTER (
SELECTCOLUMNS (
'Measure Benefit Progress List',
"MeasureID", 'Measure Benefit Progress List'[Main ID LkUpId] + 0,
"@FinancialYear", 'Measure Benefit Progress list'[Financial Year],
"Target", 'Measure Benefit Progress list'[Revised]
),
[@FinancialYear] = "2026-27"
)
RETURN
ProgressList_Target
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |