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 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

 

 

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

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    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
        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