Exclude values that are selected

[ignas]

Hey there,

I really need a bit help. I have a scatterplot which has Cost and Revenue.

Using slicer I need to filter out all GM values.

Ex. if slicer is selected from 3 to 5. Then all GM values from 3 to 5 should not be seen in the graph. 

Here is the file: https://mega.nz/#!DrJnXazJ!st7Rc_xYXhKVli6K2Sw4iUJD-9gaECOBoG8JG_zp9MI

Thanks a lot for the help

Regards,

Ignas

[v-juanli-msft · Accepted solution]

Hi @ignas

Create a new table which is not connect to your table

Table = SUMMARIZE('fact','fact'[GM])

then create measures

min = MIN('Table'[GM])

max = MAX('Table'[GM])

flag = IF(MAX('fact'[GM])<=[max]&&MAX('fact'[GM])>=[min],1,0)

Best Reagrds

Maggie

[ignas]

Hello @v-juanli-msft
It is an amazing solution.

I just have one more thing that I cannot make it working.

I need to SUMMARIZE only those lines that have column Year FY.

I cannot find any solution how I could include filter.

Link to the file: https://mega.nz/#!y6Z0TA5D!pbwZSsFrIdjiGvVXQ0cBxjHQ_KRto9GO4p7E3sTNrpU

Thanks a lot for helping

Regards,

Ignas

[v-juanli-msft · Accepted solution]

Hi @ignas

I don't see [year] column in your pbix.

If "SUMMARIZE only those lines that have column Year FY" refers to the new created table.

You could try this formula

Table=SUMMARIZE(FILTER('fact',[year]="FY"),'fact'[GM])

Best Regards

Maggie

[ignas]

Hey Maggie

You are amazing. It really works. I tried with Filter but I did something wrong.

Regards,

Ignas