Forum Discussion

carlochecchia's avatar
carlochecchia
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Decimal places showing in Matrix

Hi all,   I have a question that I am struggling with and was wondering if anyone could assist me.   I have three variables: 1. a text string (education), 2. another text string (yes or no)  3...
  • Greg_Deckler's avatar
    9 years ago

    If using Quick Measures or Show value as, I am not aware of a way to control decimal places.

  • Anonymous's avatar
    Anonymous
    9 years ago

    carlochecchia,

    You can create a calculated column using Dax below, then control decimal places of this column.

    Percent of row = Table[Weights]/CALCULATE(SUM(Table[Weights]),ALLEXCEPT(Table,Table[Yes/no]))


    Regards,
    Lydia