filterin value according total measure value

[sinanalmac]

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 ?

 

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

[themistoklis · Accepted solution]

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

Hi  @themistoklis,

 You are The best. Thank you for  your  help 

Best Regards.
Sinan