Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
FilteredProjects =
FILTER (
gold_procon_projekte_historical,
gold_procon_projekte_historical[valid_from] <= SELECTEDVALUE(gold_procon_stammdaten[stamm_daten]) &&
(
gold_procon_projekte_historical[valid_to] >= SELECTEDVALUE(gold_procon_stammdaten[stamm_daten]) ||
ISBLANK(gold_procon_projekte_historical[valid_to]) &&
gold_procon_projekte_historical[is_current] = TRUE()
)
)
Solved! Go to Solution.
@andicornejo12 - Try this:
FILTER (
ALL(gold_procon_projekte_historical[valid_from], gold_procon_projekte_historical[valid_to], gold_procon_projekte_historical[is_current]),
gold_procon_projekte_historical[valid_from] <= SELECTEDVALUE(gold_procon_stammdaten[stamm_daten]) &&
(
gold_procon_projekte_historical[valid_to] >= SELECTEDVALUE(gold_procon_stammdaten[stamm_daten]) ||
ISBLANK(gold_procon_projekte_historical[valid_to]) &&
gold_procon_projekte_historical[is_current] = TRUE()
)
)
Essentially I'm applying the filters to the specific columns inside the ALL(), rather than the whole table.
If this works for you, please accept it as the solution, it will helpwith visibility for others with the same problem.
hello @mark_endicott
Thank you so much for your answer. Unfortunately I keep getting the same error message:
@andicornejo12 - Are you attempting to use this DAX in a measure?
If so, that's likely to the problem. At the table level, the result for the flag could be both TRUE and FALSE based on the row, and a measure requires a scalar value.
If you are using a measure, try this:
VAR _table =
ADDCOLUMNS (
gold_procon_projekte_historical,
"@flag",
IF (
gold_procon_projekte_historical[valid_from]
<= SELECTEDVALUE ( gold_procon_stammdaten[stamm_daten] )
&& (
gold_procon_projekte_historical[valid_to]
>= SELECTEDVALUE ( gold_procon_stammdaten[stamm_daten] )
|| ISBLANK ( gold_procon_projekte_historical[valid_to] )
&& gold_procon_projekte_historical[is_current] = TRUE ()
),
1,
0
)
)
RETURN
MAXX ( _table, [@flag] )
It will change your flag to a integer of 1 or 0, but it can now be applied at the row level. I have tested it and it appears to be working fine for me:
@andicornejo12 - Try this:
FILTER (
ALL(gold_procon_projekte_historical[valid_from], gold_procon_projekte_historical[valid_to], gold_procon_projekte_historical[is_current]),
gold_procon_projekte_historical[valid_from] <= SELECTEDVALUE(gold_procon_stammdaten[stamm_daten]) &&
(
gold_procon_projekte_historical[valid_to] >= SELECTEDVALUE(gold_procon_stammdaten[stamm_daten]) ||
ISBLANK(gold_procon_projekte_historical[valid_to]) &&
gold_procon_projekte_historical[is_current] = TRUE()
)
)
Essentially I'm applying the filters to the specific columns inside the ALL(), rather than the whole table.
If this works for you, please accept it as the solution, it will helpwith visibility for others with the same problem.
hello @mark_endicott
Thank you so much for your answer. Unfortunately I keep getting the same error message:
Thanks so much!
Yes it did work for me too 😊
@andicornejo12 - Are you attempting to use this DAX in a measure?
If so, that's likely to the problem. At the table level, the result for the flag could be both TRUE and FALSE based on the row, and a measure requires a scalar value.
If you are using a measure, try this:
VAR _table =
ADDCOLUMNS (
gold_procon_projekte_historical,
"@flag",
IF (
gold_procon_projekte_historical[valid_from]
<= SELECTEDVALUE ( gold_procon_stammdaten[stamm_daten] )
&& (
gold_procon_projekte_historical[valid_to]
>= SELECTEDVALUE ( gold_procon_stammdaten[stamm_daten] )
|| ISBLANK ( gold_procon_projekte_historical[valid_to] )
&& gold_procon_projekte_historical[is_current] = TRUE ()
),
1,
0
)
)
RETURN
MAXX ( _table, [@flag] )
It will change your flag to a integer of 1 or 0, but it can now be applied at the row level. I have tested it and it appears to be working fine for me:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |