Calculated Dimension- Filter with set analysis

[#1]

Scenario:

I have the following fields CompanyName, Sales, Assets and AssetsFlag (has values 0 and 1).

I am giving the user a button so we can choose to see in the chart the Sales and the Assets aggr by CompanyName. But not all companies has Assets (AssetsFlag = 0). The user does not want to see in the chart the companies without Assets.

The QV documents has already many dependencies, so the best option is to add a calculated dimension.

But how can I filter the values in the calculated dimension?

That's was my ideia:

If (Button= Assets, CompanyName( -- with flag that = 1, CompanyName).

How can I create this type of calculated dimension?

Thanks in advance!

[sunny_talwar · Accepted solution]

May be this:

If(Button = Assets, Aggr(Only({<AssetsFlag = {1}>} CompanyName), CompanyName), CompanyName)

[#3]

Thank you for your help, the main functionality is working, but the name of the company comes as '-'.

But I think I can figure it out. Thanks once again!

[sunny_talwar]

You may need to select 'Suppress When Value Is Null' on the dimension tab to suppress null values in the dimension

[sunny_talwar]

If you got what you were looking for, I would suggest you to please close the thread down.

Best,

Sunny