Create a button to filter in If statement

[Daniel77]

Hi,

I have a situation where null values are created by another dimension, not true null. I can give these a value by using a count, the return will be 0, then i use if the count = 0 give a value. This is now selectable in the table. Great!

if(aggr(count([Standard Name]),[Production Facility])=0,'No Standards')

However, i now need a button to filter these values and i am struggling to get this. I have tried a few thing with non working. Like using Select values matching search criteria and the value 'No Standards' But i guess this is not a real value!

Does anyone know how i can use a button to filter the created 'No Standards' in the field Standard Name?

Thank you in advance.

Daniel

[Anil_Babu_Samineni]

Perhaps create a bookmark and use that?

[Daniel77]

Good thinking, this may be my only option! Thank you for the thought.

Daniel

[Syed_M0 · Accepted solution]

You can create the exact condition in the back end and use it for your use case.

example:

          Table:

          Load *,

          If([Standard Count] =0,'No Standards','Standard') as Flag;

          Load [Production Facility],

          count([Standard Name]) as [Standard Count]

          Resident <Your Respective Table >;

Use this Flag in the button

[Anil_Babu_Samineni]

If you got what you need, Please don't forget to close the thread.