Create slicer scale unit - change Number Formatting

[Anonymous]

Hi, 

Is it possible to create a scale slicer of units with absolute values, thousands and millions? Create a slicer with 3 options, A K M, and when choosing the unit to modify the values of the table? 

I create a disconnected table with this 3 rows : Absolute (A), MIlions (M) and Thousands(K) to use as in the slicer

And i used this example measure

Measure =
SWITCH (
    SELECTEDVALUE ( Units[Metric Unit] ),
    "A", CALCULATE( Table1[Value] ),
    "M", DIVIDE ( CALCULATE ( Table1[Value] ), 1000000 ),
    "K", DIVIDE ( CALCULATE ( Table1[Value] ), 1000 )

 but it didn't work. 

Best regards !

[Greg_Deckler · Accepted solution]

Perhaps:

Measure =
SWITCH (
    SELECTEDVALUE ( Units[Metric Unit] ),
    "A", SUM( Table1[Value] ),
    "M", DIVIDE ( SUM( Table1[Value] ), 1000000 ),
    "K", DIVIDE ( SUM( Table1[Value] ), 1000 )

[Anonymous]

@Greg_Deckler


Sometimes it's good to have someone who doesn't complicate xD. 

Thanks a lot for the help !

Best regards.