filter effecting measure division result is 100% all the time

[dexter00000]

Hi,

I've got a measure that makes a percentage out of a slicer my measure looks like this:

Measure = CALCULATE(SUM('Table'[Money]),FILTER('Table','Money'[Person]="Name")) /  CALCULATE(SUM('Table'[Money]))

but Person slicer i have is effecting the total sum  so divider is filtered but the total sum gets filtered as well so i get 100%. How do i prevent this?(If this is necessary info they are all in the same table)

I want to be able to get the percentage without needing the person filter and use a slicer instead but slicer effects all the measure i tried doing something like this

Measure= CALCULATE(SUM('Table'[Money]),FILTER('Table','Gelir Gider'[Person]=SELECTEDVALUE('Table'[Person])) / CALCULATE(SUM('Table'[Money])))

but that gives me 

A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

error 

[Avantika-Thakur · Accepted solution]

Can you try using this measure =
Measure = CALCULATE(SUM('Table'[Money]),FILTER('Table','Money'[Person]=selectedvalue('Money'[Person]))) /  CALCULATE(SUM('Table'[Money]), RemoveFilters('Money'[Person]))

[dexter00000]

this is it thank you so much

[Avantika-Thakur]

Hi,

Your person name filter would still be affecting the numerator and we are just removing its interaction with Total (Denominator)
Numerator = CALCULATE(SUM('Table'[Money]),FILTER('Table','Money'[Person]="Name")) -> which still filters the person name
Denominator =  CALCULATE(SUM('Table'[Money]), RemoveFilters('Money'[Person])) -> This won't filter the person name and instead give Total value

[Avantika-Thakur]

Hi @dexter00000 ,

Can you try with the below measure formula -
Measure = CALCULATE(SUM('Table'[Money]),FILTER('Table','Money'[Person]="Name")) /  CALCULATE(SUM('Table'[Money]), RemoveFilters('Money'[Person]))

Hope this helps!

Please accept the solution if this answers your query.

Thanks!

Avantika

[dexter00000]

but then i have to use the filter which i handpick person name i wanna be able to use the slicer to choose the person and then get their money and compare it to the total

[dexter00000]

instead of typing Person = "Name" by hand i want to use the slicer but that slicer effects the total sum too so i get 100%