Forum Discussion
specific column change subtotal value display unit only
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?
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.
1 Reply
v-jianboli-msftCommunity Support
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.