Ratio Calculation Rounding

Question

Hello, is there any way to Round down the second part of this ratio Calc&nbsp;Ratio =VAR RATIO =&nbsp; &nbsp; DIVIDE (&nbsp; &nbsp; &nbsp; &nbsp; SUM ( 'FACT - Data'[final_unique_count] ),&nbsp; &nbsp; &nbsp; &nbsp; SUM ( 'FACT - Volumes'[Volume] )&nbsp; &nbsp; )RETURN&nbsp; &nbsp; CONCATENATE ( "1", CONCATENATE ( " : ", Ratio ) )&nbsp;

philiptreacy · Accepted Answer

NewbieJono&nbsp;
&nbsp;
Use ROUNDDOWN, for example to 2 decimal places
&nbsp;
&nbsp;
RETURN
    CONCATENATE ( "1", CONCATENATE ( " : ", ROUNDDOWN(Ratio, 2) ) )
&nbsp;
&nbsp;
https://learn.microsoft.com/en-us/dax/rounddown-function-dax
&nbsp;
Regards
&nbsp;
Phil

Forum Discussion

Related content

Rounding

Ratio Calculation

CALCULATE Challenge - Round 1

No CALCULATE Challenge -- Round #2

ratio calculation