Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
dexter00000
Helper I
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
Avantika-Thakur
Solution Supplier
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]))

View solution in original post

6 REPLIES 6
Avantika-Thakur
Solution Supplier
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]))

this is it thank you so much

Avantika-Thakur
Solution Supplier
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

Avantika-Thakur
Solution Supplier
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!

Please accept the solution if this answers your query.

Thanks!

Avantika

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

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% 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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