cancel
Showing results for
Did you mean:

## Exclude values that are selected

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.

Thanks a lot for the help

Regards,

Ignas

2 ACCEPTED SOLUTIONS
Community Support

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

Community Support

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

4 REPLIES 4
Community Support

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

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.

Thanks a lot for helping

Regards,

Ignas

Community Support

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

Hey Maggie

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

Regards,

Ignas

Announcements