format a measure differently for a table

[mikebi]

Hello,

I have a measure for Sales which does a Calculate and Sum.  I have this formatted as Currency.

For a new table visual, I would like to format this measure for Millions but I don't want to change the other visuals that use this measure.

Is there a way in the table to define a format for this measure?  I don't want to have to create a new measure just for this visual.

Thank You,

Michael

[mikebi]

Thank You!

[PijushRoy]

You are welcome

[PijushRoy · Accepted solution]

Hi @mikebi 

Please implement below configuration 

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks