Forum Discussion

TimAnymouse's avatar
TimAnymouse
Regular Visitor
5 years ago
Solved

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 Female...
  • HotChilli's avatar
    HotChilli
    5 years ago

    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.

HotChilli's avatar
HotChilli
Community Champion
5 years ago

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's avatar
    TimAnymouse
    Regular Visitor
    5 years ago

    Thanks, it was a leading space.