cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sinanalmac Regular Visitor
Regular Visitor

filterin value according total measure value

Hi, all  I have simple forecasting values. I want to filter FU  percentage values according to Total accuracy values.

accuary  calculation  :


AccuracyBias = 1-(SUM(Bias[ABS Dif])/SUM(Bias[Sales]))


I want to show FU values which they  below the total value of the selected month. is there a simple  solution  or not ?


accuary.png 

 

 

I'm shaing the files  with you. Please find the link  below.
https://www.dropbox.com/sh/rrcmf97oupdb3fr/AAAEW6-mDPVOjc6k5WBKS90ba?dl=0

Thank you  Best regards

1 ACCEPTED SOLUTION

Accepted Solutions
themistoklis New Contributor
New Contributor

Re: filterin value according total measure value

@sinanalmac

 

Please see attached new powerbi workspace on this link

 

I just create a new measure and then one filter to filter the rows.

 

AccuracyBias_Total = 1-(CALCULATE(SUM(Bias[ABS Dif]), ALLSELECTED(Bias[FU ]))/CALCULATE(SUM(Bias[Sales]), ALLSELECTED(Bias[FU ])))
Filter_Rows = IF([AccuracyBias] < [AccuracyBias_NEw],1,0)

 

2 REPLIES 2
themistoklis New Contributor
New Contributor

Re: filterin value according total measure value

@sinanalmac

 

Please see attached new powerbi workspace on this link

 

I just create a new measure and then one filter to filter the rows.

 

AccuracyBias_Total = 1-(CALCULATE(SUM(Bias[ABS Dif]), ALLSELECTED(Bias[FU ]))/CALCULATE(SUM(Bias[Sales]), ALLSELECTED(Bias[FU ])))
Filter_Rows = IF([AccuracyBias] < [AccuracyBias_NEw],1,0)

 

sinanalmac Regular Visitor
Regular Visitor

Re: filterin value according total measure value

Hi  @themistoklis,

 You are The best. Thank you for  your  help 

Best Regards.
Sinan 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 35 members 951 guests
Please welcome our newest community members: