Dimension in table with exclusions

[MikeJones]

Hi, I am wishing to create a table with the dimension that excludes where the status is unknown.  In my example below there would be only 3 employees.  I don't wish to use a filter pane.

Employee	Status		Employee
Andrew	Known		Mike
Brandon	Unknown		Andrew
Gill	Known		Gill
Jonathan	Unknown
Mike	Known

[MatheusC]

Hello, @MikeJones 
You could try this in your load editor, restricting your table to only bring in Known status data.

Load

    your table

From [] (qvd) Where Status='Conhecido';

[MikeJones]

Thanks, Matheus for your idea.  However, on another sheet I need to have all the data showing.

Any other ideas?

[vinieme12]

There are two options you can restrict data in table or any chart

1) Restrict with the Measure: by using set analysis in all measures in the chart

for example

Dimension : Employee

Measure : count({<Status-={'Unknown'}>}Employee) 

2) Restrict dimension values: by using a Calculated dimension 

Dimension = Aggr(only({<Status-={'Unknown'}>}Employee) , Employee)

Measure = Count(Employee)