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
Just try to modify your measure for not fulfilment
%Not Fulfilment = 1- ('Outbound Delivery'[Total Actual]/'Outbound Delivery'[Total Demand])
I hope this what you are trying to achieved.
Uzi2019 Hi, I tried your solution and it has same problem as other solutions that I tried.
It as well calculates for rows that do not have any data which is what I am trying to prevent.
I would hope end result would look like this but data in the red circle would be that 1.5% data.Uzi2019 I tied to filter out blank values but that only partialy helps.
It does not filter out if there is even one value in day column
