Forum Discussion
Not fulfilled %
Hi Justas4478 ,
Thank you Uzi2019 for your prompt reply, I have created a sample data for you to help you solve your problem. You can follow the steps below:
Sample data:
1.Add a new column:
%Not Fulfilment = VAR _All = 1 - ( 'Outbound Delivery'[Total Actual] / 'Outbound Delivery'[Total Demand] ) RETURN IF ( 'Outbound Delivery'[Total Actual] = BLANK () || 'Outbound Delivery'[Total Demand] = BLANK (), BLANK (), _All )Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Justas4478 ,
Thank you Uzi2019 for your prompt reply, I have created a sample data for you to help you solve your problem. You can follow the steps below:
Sample data:
1.Add a new column:
%Not Fulfilment =
VAR _All = 1 - ( 'Outbound Delivery'[Total Actual] / 'Outbound Delivery'[Total Demand] )
RETURN
IF (
'Outbound Delivery'[Total Actual] = BLANK ()
|| 'Outbound Delivery'[Total Demand] = BLANK (),
BLANK (),
_All
)
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Hi, it works.
Thank you for the solution.Would it be possible to explain how the measure works if its not to much to ask?
Hi Justas4478 ,
Sure, I would be happy to answer that for you. As the result of the calculation will include the blank values in the data as well. You can remove the blank data after listing the equation to eliminate its effect on the result.Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Thank you for explaining and the help.
