Forum Discussion
Calculate Rejections based on filtering
Hi Guys
I am looking to dynamically calculate rejections based on selection of Reason for Rejection
See screenshot below, basically there can be multiple Order_IDs as the order goes through the approval process. You can see that 70001 was rejected on the 12th i.e. the Right First Time (RFT) should show 0, as there has been at least 1 rejection.
However the issue is as requirements change very often, the end user wants to be able to filter out Reason for Rejection, therefore if LOC_Editorial correction is filtered out via slicer the 18-Jan-22 row should show 1 (as there are now technically no previous or future rejections associated)
Have tried a fair few variations of the below but to no avail, if anyone can see where I am going wrong please give me a shout!
DisplayValue =
VAR SelectedReasonCount = [SelectedReasonCount]
VAR BlankReasonCount =
COUNTROWS(
FILTER(
'lnd AWComponentLibraryApproval',
ISBLANK('lnd AWComponentLibraryApproval'[Reason_for_rejection])
)
)
RETURN
IF (
SelectedReasonCount = 0 && BlankReasonCount > 0,
1,
0
)
3 Replies
Hi jbeans ,
I'm not clear about your requirement. Is the field [LOC RFT Calculation] the one which you want to get finally? What's the calculation logic? Does the value of the field [LOC RFT Calculation] change with the slicer option? Or is it 1 if the field [Reason_for_rejection] is blank,otherwise 0. Are there any other restrictions? Could you please provide more sample data and specific examples to illustrate your requirements?
Best Regards
Hey Anonymous , please let me rephrase. I would like to return the earliest date that has been DESELECTED from a slicer. Not sure if it is even possible in Power BI?
Hi jbeans ,
I still can't clear your requirement. Could you please explain it with the special examples? Thank you.
Best Regards
