Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

New Measure - Percentage based on two quantities

Morning All,   I've used commnity support in the past on things such as VBA and again more recently following a D365 go-live and learning to link PBI and Dynamics.. From pulling a warehouse cycl...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

If you want a dynamic [ExpectedQuantity], you can try what-if parameters.

After the what-if parameter is created, you get a dynamic [ExpectedQuantity] that can be modified by slicers.

Here's the measure to calculate the percentage.

Percentage = 
var _CountedQuantity=CALCULATE(COUNT('Table'[ID]),FILTER(ALLSELECTED('Table'),[ID]=MAX('Table'[ID])))
return DIVIDE([ExpectedQuantity Value],_CountedQuantity)

 

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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