cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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%

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors