Forum Discussion
Exclude values that are selected
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
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
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
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