Filter specific data

[Anonymous]

Hello,

How can I filter specific data?

I want to delete or want to show the data excluding ("All") in the graph.

I have tried to set the range min/max but it didnt work.

I want the graph to show the data starting from -500 and assending order.

can you please help me out eith this.

Thank you,

Sachin

[YoussefBelloum]

Hi,

can you add more details ? the dimension, the expression.. the qvf file ?

[Anonymous]

Hello,

I am sorry, cannot add qvf file.

The dimensions are Customer name and Gross margin

And the expression in gross margin is

((Sum({$<[Year]={"2017"}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"}>}[Gross Margin Actual Year])))

Regards,

Sachin

[YoussefBelloum]

Try to uncheck "include null values" on the dimension parameters

[Anonymous]

It Is unchecked.

[YoussefBelloum]

so you have a value called "All" in your dimension field ?

[Anonymous]

Yes & I want to exclude only that value in the graph and show the remaininng values.

[YoussefBelloum]

so here it is:

((Sum({$<[Year]={"2017"},Customer-={'All'}>}[Gross Margin Actual Year])) - (Sum({$<[Year]={"2016"},Customer-={'All'}>}[Gross Margin Actual Year])))

[Anonymous]

No this does not works. It still gives me the value "All"

[vinieme12 · Accepted solution]

Exclude dimension value in your SetAnalysis

((Sum({$<[Year]={2017} , [CustomerName]-={'All'}>}[Gross Margin Actual Year]))

- (Sum({$<[Year]={"2016"},, [CustomerName]-={'All'}>}[Gross Margin Actual Year])))

Set Analysis: syntaxes, examples