Forum Discussion

Starlord's avatar
Starlord
New Member
7 years ago
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...
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    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.

AkhilAshok's avatar
AkhilAshok
Solution Sage
7 years ago

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.

Starlord's avatar
Starlord
New Member
7 years ago

Yes that was the problem i had some space infront of the Gender.

 

Thank you so much for your help Akhil !!!!