Forum Discussion
Solved
dynamically exclude records based on user defined conditions
Hi all, and thank you for any suggestion with this little issue. This is a semplified example, but my real model works the same way. I have a projects table (every row is a project) and a Localizat...
Michele_I Well, if it works, it works. Probably not how I would have done it. I would have probably done something like:
Budget OK = VAR __Table = FILTER( ADDCOLUMNS('Projects', "__Selected", [Selection Measure]), [__Selected] = 1) VAR __Result = SUMX(__Table, [budget]) RETURN __Result
Greg_Deckler
Community Champion
Community ChampionMichele_I Well, if it works, it works. Probably not how I would have done it. I would have probably done something like:
Budget OK =
VAR __Table = FILTER( ADDCOLUMNS('Projects', "__Selected", [Selection Measure]), [__Selected] = 1)
VAR __Result = SUMX(__Table, [budget])
RETURN
__Result
Greg_Deckler Your way is much better 🙂
Thank you very much!