Ratio Calculation Rounding

NewbieJono 

Use ROUNDDOWN, for example to 2 decimal places

RETURN
    CONCATENATE ( "1", CONCATENATE ( " : ", ROUNDDOWN(Ratio, 2) ) )

https://learn.microsoft.com/en-us/dax/rounddown-function-dax

Regards

Phil

Hi NewbieJono 

Thanks for the reply from PhilipTreacy .

You can also try using ROUND. The following test is for your reference:

Sample:

Create a measure as follows

Radio = 
VAR _radio = SUM('FACT - Volumes'[Volume])
RETURN
CONCATENATE("1", CONCATENATE(":", ROUND(_radio, 10)))

In your scenario you can directly change the formula:

Ratio =
VAR RATIO =
    DIVIDE (
        SUM ( 'FACT - Data'[final_unique_count] ),
        SUM ( 'FACT - Volumes'[Volume] )
    )
RETURN
    CONCATENATE ( "1", CONCATENATE ( " : ", ROUND(RATIO, "Specify the number of digits to round off") ) )

Output:

For more details about the ROUND function, you can read related document link:

ROUND function (DAX) - DAX | Microsoft Learn

Best Regards,
Yulia Xu

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