Forum Discussion

ignas's avatar
ignas
Advocate II
7 years ago
Solved

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 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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's avatar
ignas
Advocate II
7 years ago

Hey Maggie

 

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


Regards,

 

Ignas