Forum Discussion
Calculate function with Boolean filter
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
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.
2 Replies
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.
Thanks, it was a leading space.
