Forum Discussion

MarcUrdang's avatar
MarcUrdang
Post Patron
4 years ago
Solved

percentages

Hi .. I posted a question a moment ago but cannot find it .. I must say I find this forum tricky to navigate .. anyway I'm looking for adivice on how to obtain a %. I have to fields: Forcast and Ware...
Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi MarcUrdang ,

    According to your description, here's my solution.

    Create a measure.

    aaFill measure column 2 =
DIVIDE (
    [aaFill measure column 4],
    CALCULATE ( SUM ( 'Ops Data'[aQtyEXTRACT Forecast Qty] ), ALL ( 'Ops Data' ) )
)

    Get the correct result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

MarcUrdang ,

new measure = divide(sum('Ops Data'[aQtyEXTRACT Stock on Hand]), Calculate(sum('Ops Data'[aQtyEXTRACT Forecast Qty]), allselected()))

MarcUrdang's avatar
MarcUrdang
Post Patron
4 years ago

HI Amit .. nice to hear from you again ... long time 🙂

 

I see that the calc at least works better but still not accurate ... I remember we Skyped last time .. if you would be willing to take another call sometime today I would be happy to pay for your time ... I'm sure 10 mins would put this to bed .. 

 

thx

Marc