Forum Discussion
Measure not filtering correctly (But sometimes does)
Davidian Using measures in the filter clause of a CALCULATE can do wacky things. I generally use VAR statements to do this instead so something like.
LiabilitySumWithFilter = VAR __FLDateBeforeDate = [FLDate Before Date] VAR __SelectedPortfolioFulcrumEntityId = [SelectedPortfolioFulcrumEntityId] VAR __Result = CALCULATE(SUM(FundingLevel[LiabilityValue]), FILTER(FundingLevel,FundingLevel[Date]=__FLDateBeforeDate &&FundingLevel[Portfolio_FulcrumEntityId]=__SelectedPortfolioFulcrumEntityId )) RETURN __ResultYet another reason to not use CALCULATE...
Community ChampionDavidian Using measures in the filter clause of a CALCULATE can do wacky things. I generally use VAR statements to do this instead so something like.
LiabilitySumWithFilter =
VAR __FLDateBeforeDate = [FLDate Before Date]
VAR __SelectedPortfolioFulcrumEntityId = [SelectedPortfolioFulcrumEntityId]
VAR __Result =
CALCULATE(SUM(FundingLevel[LiabilityValue]), FILTER(FundingLevel,FundingLevel[Date]=__FLDateBeforeDate &&FundingLevel[Portfolio_FulcrumEntityId]=__SelectedPortfolioFulcrumEntityId ))
RETURN
__ResultYet another reason to not use CALCULATE...
Awesome, thank you Greg_Deckler - I will try this on monday (caught the email as I was just wrapping up for the weekend)
Sounds like a sensible option to go with the measures.
It might alctually solve some other issues I had that I ended up doing different way in the back end (as using SQL ended up being much easier)Thank you, and have a good weekend!
Good morning, hope you had a fantastic weekend.
Just wanted to say thanks again, I have started going through my formula replacing them with the methodology you mention and it seems to be working (the figures are correct like my "long winded" versions) so thank you so much for that.
Seems really strange measures operate that way - is this an "error" with Dax that one just has to accept and will likely never be fixed, or is it actually considered a "feature"? lol
