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.