specific column change subtotal value display unit only

[Anonymous]

Hi all,

I want to change the display units value in a subtotal only. However, it also changes the values in the matrix also, which is not what I'm wanting. Is there a way to show the subtotals in "Thousands", but keep the main body values as "none". I'm selecting the options "Apply to subtotals" = On and "Apply to values" = Off

This works fine for the Text / background color and Alignment, but not Display Unit

Or is this a bug? 

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

Please try to use a measure like this:

Measure = IF(ISINSCOPE('Table'[ID])&&ISINSCOPE('Table'[Category]),SUM('Table'[Value]),(SUM('Table'[Value])/1000)&"K")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.