Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago
Solved

Not fulfilled %

Hi, I have this measure

% Fulfilment = 'Outbound Delivery'[Total Actual]/'Outbound Delivery'[Total Demand]
It calculates number of fulfilment. Results number for example 0.985 and so on.
I change it to a % and get 98.5% and it works fine.
I as well need to create measure that calculates amount that is not fulfiled.
If we follow example not fulfiled would be 1.5%, but none of the measures that I tried seam to work correctly when I add them to the table.
Anyone would be able to help.
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

7 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    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.

     

    • Justas4478's avatar
      Justas4478
      Post Prodigy
      2 years ago

      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.

       

       

      • Justas4478's avatar
        Justas4478
        Post Prodigy
        2 years ago

        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

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • Justas4478's avatar
      Justas4478
      Post Prodigy
      2 years ago

      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?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.