topic Re: Calculate function with Boolean filter in DAX Commands and Tips

Calculate function with Boolean filter

TimAnymouse — Wed, 02 Jun 2021 14:07:39 GMT

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

Re: Calculate function with Boolean filter

HotChilli — Wed, 02 Jun 2021 15:31:24 GMT

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.

Re: Calculate function with Boolean filter

TimAnymouse — Wed, 02 Jun 2021 18:12:36 GMT

Thanks, it was a leading space.