cancel
Showing results for
Did you mean:
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 ?

https://www.dropbox.com/sh/rrcmf97oupdb3fr/AAAEW6-mDPVOjc6k5WBKS90ba?dl=0

Thank you  Best regards

1 ACCEPTED SOLUTION

Accepted Solutions
New Contributor

## Re: filterin value according total measure value

@sinanalmac

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
New Contributor

## Re: filterin value according total measure value

@sinanalmac

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

Regular Visitor

## Re: filterin value according total measure value

Hi  @themistoklis,

You are The best. Thank you for  your  help

Best Regards.
Sinan

Announcements

#### 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

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

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 35 members 951 guests
Recent signins: