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
Go to Solution.
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)
Hi @themistoklis, You are The best. Thank you for your help Best Regards.Sinan
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.