Reference non-measures in calculations and agents?

Mads Høgenhaug ·

Hello!

I have some dummy data that contains (1) Country (2) Airline  (3) Passengers

I want to hide all the countries that only has one Airline associated with it.
However, when I try to do an allcount (or a count as well), it won't let be choose the two first columns. d1 and d-1 both reference the passengers column. 

Is there a way to count the amount of Airlines a country has, and then filter based on that?

Below is a screenshot of the dummy data


 Country                                                                          Airline Code                                   #passengers

1

Comments

2 comments
Sort by DateVotes
  • Marlene Knaup

    Hi, you can try to hide a member of #passengers with this formula:

    allcount(d-1, all(s), 0) = 1

    Your three countries should be invisible then. 

    Please tell me if this helped :)

    0
  • Mads Høgenhaug

    It worked! Thanks a lot!

    0
Please sign in to leave a comment.