Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
6 years ago
Solved

Matrix SubTotal Column Different Number Format Than Field Column

Hi all,   Using Desktop 2.78.5. How can I add a different number format to the Column Subtotal in my Matrix that is different from Field Formatting. My Fields are formatted to to display Thousand...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    It is a little different from my dax expression about the field in ISINSCOPE function.

    This field should be the [Type] in my test table not the [Value]:

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try this measure to replace original value:

Measure = IF(ISINSCOPE('Table'[Type]),SUM('Table'[Value])/1000&"K",FIXED(SUM('Table'[Value])/1000000,0)&"M")

The result shows:

Tips: By this way, the value's format will convert to text.

Hope this helps.

 

Best Regards,

Giotto Zhi

UncleLewis's avatar
UncleLewis
Responsive Resident
6 years ago

Thanks Giotto,

 

Definitely on the right track. However, all of my numbers show up as Millions?

I believe my DAX formula is the same as yours?

 

Population_Text = If(ISINSCOPE(Population[Population Est]),SUM(Population[Population Est])/1000&"K",FIXED(SUM(Population[Population Est])/1000000,1)&"M")
 
Thanks,
-w
  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    It is a little different from my dax expression about the field in ISINSCOPE function.

    This field should be the [Type] in my test table not the [Value]:

     

    Best Regards,

    Giotto Zhi