cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper I

## filter effecting measure division result is 100% all the time

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

1 ACCEPTED SOLUTION
Solution Supplier

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

6 REPLIES 6
Solution Supplier

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

Helper I

this is it thank you so much

Solution Supplier

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

Solution Supplier

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!

Thanks!

Avantika

Helper I

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

Helper I

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%