Filter Clear

[vjnvinod]

Hi  All
below is my table visual in power BI

i have a slicer for Period which has a value, 1,2,3..12

what i need is, when i select any period lets say period: 2, 3, or any period

my first coloumn that is Total MLO should not get filtered

Below is how the Total MLO is calculated

Total MLO = SUM(Input[Sum of MLO])

let me know how do i do this?

[amitchandak]

It would great if period is part of another table try

Total MLO = calculate(SUM(Input[Sum of MLO]),all(Input[period]))

Or

Total MLO = calculate(SUM(Input[Sum of MLO]),all(period[period]))

[JCPO · Accepted solution]

hI @vjnvinod ,

Just create a new Measure with the following and replace what's in the matrix.:

*Measure = CALCULATE(SUM('Table'[Total MLO]),REMOVEFILTERS('Table'[Period]))

Cheers!

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490