Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional decimals

Hi, I have a Measure and it's calculating correctly, Initially I've a requirement from user to always display only one Decimal UP on a Matrix Visual. so I've used ROUNDUP([SalesAvg],1). But the isue...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Don't know what is the upper level of the matrix but you should place a measure similar to the one below replacing the Column name with the lowest level:

    Measure =
IF (
    HASONEFILTER ( 'Table'[cat2] );
    FORMAT ( ROUNDUP ( [SalesAvg]; 2 ); "0.00" );
    FORMAT ( ROUNDUP ( [SalesAvg]; 1 ); "0.0" )
)

    This will make the 2 decimal and format with the number of decimal places you need.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Don't know what is the upper level of the matrix but you should place a measure similar to the one below replacing the Column name with the lowest level:

Measure =
IF (
    HASONEFILTER ( 'Table'[cat2] );
    FORMAT ( ROUNDUP ( [SalesAvg]; 2 ); "0.00" );
    FORMAT ( ROUNDUP ( [SalesAvg]; 1 ); "0.0" )
)

This will make the 2 decimal and format with the number of decimal places you need.

 

Regards,

MFelix