Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Removing decimals from values while keeping for totals

Hi, I have table that has some counts. However I cant find a way how I could remove delimal points from values in red square while keeping decimal points for values in green square. I tried couple ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Unfortunately, with live connection, you will need to apply the dynamic format string to the measure in the semantic model itself. Alternatively, you can create another measure that returns a formatted text instead

    IF (
    NOT ( HASONEVALUE ( Geo[Geo] ) ),
    FORMAT ( [my measure], "#,#.00" ),
    FORMAT ( [my measure], "#,#" )
)
Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
1 year ago

danextian I quickly looked in to and it seasm I cant create dinamic format since it is on for model measures and not ones using live connection.

 

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Unfortunately, with live connection, you will need to apply the dynamic format string to the measure in the semantic model itself. Alternatively, you can create another measure that returns a formatted text instead

IF (
    NOT ( HASONEVALUE ( Geo[Geo] ) ),
    FORMAT ( [my measure], "#,#.00" ),
    FORMAT ( [my measure], "#,#" )
)
  • Justas4478's avatar
    Justas4478
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    danextian It works thanks for the solution.
    To bad that it doubles refresh time.

    But I guess this is only option I have.