Need help creating a measure named Percentage by using Balance,Increase and Decrease columns.

[assistant_sense]

[Anonymous · Accepted solution]

Hi  @assistant_sense ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _maxvalue=MAXX(ALL('Table'),[Increase])
var _value=
IF(
    MAX('Table'[Increase])=BLANK(),
 DIVIDE(  
SUMX('Table',[Decrease]),_maxvalue),
DIVIDE(
    SUMX('Table',[Increase]),_maxvalue))
return
IF(
    _value=BLANK() && MAX('Table'[Balance])<>BLANK(),
    0,_value)

2. Result:

Best Regards,

Liu Yang

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