Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculation based on a parameter

Hi,    I'm trying to create a calculation based on a what if parameter, presented using a slicer.    The parameter (X) will take any value between 1 to 100.    There are four co...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    You can use measure like bleow:

     

    Measure = IF (
    MAX ( Table[current compliance level] ) + [perc_compliance Value] > 1,
    ( 1 - MAX ( Table[current compliance level] ) ) * Table[annual target case] * Table[avg sales per case],
    [perc_compliance Value] * Table[annual target case] * Table[avg sales per case]
)

     

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

     

    Best Regards,

    Dedmon Dai

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

You can use measure like bleow:

 

Measure = IF (
    MAX ( Table[current compliance level] ) + [perc_compliance Value] > 1,
    ( 1 - MAX ( Table[current compliance level] ) ) * Table[annual target case] * Table[avg sales per case],
    [perc_compliance Value] * Table[annual target case] * Table[avg sales per case]
)

 

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

 

Best Regards,

Dedmon Dai