Convert C to DAX

@NickProp28

Try these two measurements for 20 and 10

20 Plt = 

INT(DIVIDE(SUM(TABLE[NO OF PACKAGES]),20))

10 Plt = 

ROUNDUP(MOD(sum(TABLE[NO OF PACKAGES]),20),-1)/10

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click the Thumbs-Up icon on the right if you like this answer 🙂

YoutubeLinkedin

Hello, @NickProp28

According to your description, I created data to reproduce your scenario. The pbix file is attached at the end.

Mesa:

You can create a measure like the following.

Result = 
var _value = SUM('Table'[No of Packages])
var _num20 = INT(DIVIDE(_value,20))
var _remain1 = MOD(_value,20)
var _num10 = ROUNDUP(DIVIDE(_remain1,10),0)
var _remain2 = MOD(_remain1,10)
return
IF(
    _value>20,
    IF(
        _remain1>0,
        _num20&" 20s pallet and "&_num10&" 10s pallet",
        _num20&" 20s pallet"
    ),
    INT(DIVIDE(_value,10))&" 10s pallet"
)

Result:

Best regards

Allan

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

@NickProp28

It rounds one decimal place to the left of the decimal point.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, Linkedin