0

Hi guys I have a problem with simple dataset

In the table I get the same results for the count of Child friendly resort whether is by country or by continent.

My model seem to be in good shape since it doesn't happen with values from other columns

this is the measure being used

Count of Children friendly resorts = calculate( COUNTROWS( 'Resort Classification Dim'), Filter( ALL( 'Resort Classification Dim'),
'Resort Classification Dim'[Child Friendly]=TRUE)

                                   )

data table Model

I tried changing the data type from true or false to text so I can try using countx on the measure but didn't make a difference

any advice? thanks in advance

73x
  • 1
  • 1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Mar 17 '23 at 05:30

1 Answers1

0

When you do ALL you are clearing the filter context on the table, you don't want to do that. Can be changed to:

Count of Children friendly resorts = calculate( COUNTROWS( 'Resort Classification Dim'), Filter('Resort Classification Dim'),
'Resort Classification Dim'[Child Friendly]=TRUE))

or simply

Count of Children friendly resorts = calculate( COUNTROWS( 'Resort Classification Dim'),'Resort Classification Dim'[Child Friendly]=TRUE)
Joao Leal
  • 5,533
  • 1
  • 13
  • 23