Forum Discussion
Solved
Calculate Filter not working
Hi there I am having a problem with DAX calculate and filter measure. PopulationFemale = Calculate( SUM ( 'FACT-Population'[Population] ), Filter( 'FACT-Population','FACT-Population'[Gender...
Then only problem I can think of is that, there is some spaces in Gender dimension. Try Transform -> Trim for Gender column in Query Editor.
Hi there
I dont have any sync slicers enabled to filter for male.
I tried the below but still shows blank.
PopulationFemale = CALCULATE (sum ('FACT-Population'[Population]),'FACT-Population'[Gender] = "Female")
Then only problem I can think of is that, there is some spaces in Gender dimension. Try Transform -> Trim for Gender column in Query Editor.
Yes that was the problem i had some space infront of the Gender.
Thank you so much for your help Akhil !!!!