Forum Discussion

Liklikadze's avatar
Liklikadze
Regular Visitor
4 years ago
Solved

Help/Can't Write Bonus system code

Im trying to write Bonus system code where Productoutinfo.Sacalo is just an number like price. If Productoutinfo.Sacalo is more then 500 it must write 0.01 * Productoutinfo.Sacalo. If its from 500 to...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    Liklikadze , Try a measure like

     

    measure =
    var _sum = sum( Productoutinfo[Sacalo])
    return
    sumx( Table,
    Switch(True() ,
    _sum <= 500 , _sum *.01 ,
    _sum <= 1000 , 20,
    _sum *.02
    )
    )

     

    Or use group by of visual in values 

    measure =
    var _sum = sum( Productoutinfo[Sacalo])
    return
    sumx( values(Table[column]) ,
    Switch(True() ,
    _sum <= 500 , _sum *.01 ,
    _sum <= 1000 , 20,
    _sum *.02
    )
    )

amitchandak's avatar
amitchandak
Super User
4 years ago

Liklikadze , Try a measure like

 

measure =
var _sum = sum( Productoutinfo[Sacalo])
return
sumx( Table,
Switch(True() ,
_sum <= 500 , _sum *.01 ,
_sum <= 1000 , 20,
_sum *.02
)
)

 

Or use group by of visual in values 

measure =
var _sum = sum( Productoutinfo[Sacalo])
return
sumx( values(Table[column]) ,
Switch(True() ,
_sum <= 500 , _sum *.01 ,
_sum <= 1000 , 20,
_sum *.02
)
)

Liklikadze's avatar
Liklikadze
Regular Visitor
4 years ago

Someone give this man Power BI medal. Thanks a lot