Forum Discussion

sinanalmac's avatar
sinanalmac
Icon for Resolver I rankResolver I
7 years ago
Solved

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 ?


 

 

 

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

Need Help
Show and Tell
Tips and Tricks
  • themistoklis's avatar
    themistoklis
    7 years ago

    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

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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)