Decimal places showing in Matrix

[carlochecchia]

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. numerical values (weights)

I would like to calculate the percentage of people who said yes/no based on their education level.

Ive created the following matrix:

1. yes/no variable in the line

2.education on the columns

3. weights on value (ive asked it to calculate based on the percentage of the row)

Everything works fine but i cant get rid of the 2 decimals in my results. 

Can anyone help, please?

[Greg_Deckler · Accepted solution]

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

[v-yuezhe-msft · Accepted solution]

@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

[Greg_Deckler · Accepted solution]

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

[carlochecchia]

Thats what i thought. Thanks for the reply