Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
If using Quick Measures or Show value as, I am not aware of a way to control decimal places.
@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
@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
If using Quick Measures or Show value as, I am not aware of a way to control decimal places.
Thats what i thought. Thanks for the reply