Calculate function with Boolean filter

[TimAnymouse]

Good Afternoon,

Hopefully someone can help me with the below.

I am trying to create the below measure but get a blank value when used with a card visual with no filter

Gender Ratio =
var FemalePopulation = CALCULATE(Countries[Population], Countries[Gender] = "Female")
var MalePopulation = CALCULATE(Countries[Population], Countries[Gender] = "Male")

Return
DIVIDE(FemalePopulation, MalePopulation)

As a test I tried the below which also returns blank

test = CALCULATE(AVERAGE(Countries[Population]), (Countries[Gender] = "Male"))

I then tried to use summarize but got a syntax error

Table =
SUMMARIZE(Countries,Countries[Country Code],Countries[Age Range],Countries[Year],
DIVIDE(
CALCULATE (Countries[Population], Countries[Gender] = "Female"),
CALCULATE(Countries[Population], Countries[Gender] = "Male"))
)

Kind regards,

Tim

[HotChilli · Accepted solution]

There's no aggregation i.e. SUM, COUNT, AVERAGE in the first measure shown.

The 2nd one will give results if the datatypes on the columns are correct and there's no spaces or case differences in the Gender column.

2 things to try:

Can you post a small sample of data please (not a picture) and say what the desired outcome is?

 Maybe you could create a measure 

AVERAGE(Countries[Population])

and just test that on a card.  You could apply a filter from the filter pane (using Gender to test Male/Female) to further test.

[TimAnymouse]

Thanks, it was a leading space.