Reference non-measures in calculations and agents?

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
  • 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
  • It worked! Thanks a lot!

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post