Forum Discussion

lennox25's avatar
lennox25
Icon for Post Patron rankPost Patron
2 years ago
Solved

How to work out % Over Deadline

Out of total no of products delivered. I need to know how many were sold within the Deadline Date. I extracted from PBI into Excel to show you what I require and worked out but cant figure how to do ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi lennox25 ,

    You can create a meausre as below to get it:

    Over Deadline Percentage = 
VAR _all =
    CALCULATE ( COUNT ( 'Table'[Date Arrived] ), ALLSELECTED ( 'Table' ) )
VAR _delay =
    CALCULATE (
        COUNT ( 'Table'[Date Arrived] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Days Over Deadline] >= 0 )
    )
RETURN
    DIVIDE ( _delay, _all )

    Best Regards

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

lennox25 
Hope you are using as a measure
Days Over Deadline is numeric datatype

lennox25's avatar
lennox25
Icon for Post Patron rankPost Patron
2 years ago

Yes, but when I work it on excel it has different % to whats on PBI ad I dont know why Measure 2 (the one you provided is coming out at 100% for all the over deadline ?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi lennox25 ,

    You can create a meausre as below to get it:

    Over Deadline Percentage = 
VAR _all =
    CALCULATE ( COUNT ( 'Table'[Date Arrived] ), ALLSELECTED ( 'Table' ) )
VAR _delay =
    CALCULATE (
        COUNT ( 'Table'[Date Arrived] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Days Over Deadline] >= 0 )
    )
RETURN
    DIVIDE ( _delay, _all )

    Best Regards