Forum Discussion

ignas's avatar
ignas
Icon for Advocate II rankAdvocate 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
Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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
        Icon for Advocate II rankAdvocate II
        7 years ago

        Hey Maggie

         

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


        Regards,

         

        Ignas