Forum Discussion
Anonymous
2 years agoNot applicable
Function returning blank in DAX
testing =
VAR extractCampaignYear = IF (ISFILTERED('Campaign Overview'[campaign]),VALUE(MIN('Campaign Overview'[previousExtractedYear])),0)
RETURN
SUMX(
FILTER(
SUMMARIZE (
'Campaign Over...
- Anonymous2 years ago
I actually managed to solve it, its because when I filter something with my slicer it also filters the summarized table so I needed to add removefilters() within my DAX code like so:
testing = VAR extractCampaignYear = IF (ISFILTERED('Campaign Overview'[campaign]),MIN('Campaign Overview'[previousExtractedYear]),0) RETURN CALCULATE( SUMX( FILTER( SUMMARIZE ( 'Campaign Overview', 'Campaign Overview'[campaign], "extractedCampaign",TRIM(MIN('Campaign Overview'[extractedCampaignName])), "campaignYear", MIN('Campaign Overview'[extractedYearFromCampaign]), "Sales", SUM ( 'Campaign Overview'[sales] ) ), [campaignYear] = extractCampaignYear), [Sales]), REMOVEFILTERS() )
AlexisOlson
Super User
2 years agoI'm not seeing any unexpected behavior.
matches
Using 2022 is different when no campaign is selected because extractCampaignYear variable is 0 in this case.