Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Avg1-1%
Avg2-2%
Avg3- 4%
In Matrix when I drag this average measure in total I get avg value-2.3% but I have to get sum=7%.pls help me to achieve this?
please use
SUMX (
VALUES ( 'Table'[the slicing by column at rows of the matrix] ),
[Average Measure]
)
or
If you are slicing by multiple columns from different tables then
SUMX (
SUMMARIZE ( 'Fact Table', 'Dim Table1'[columnX], 'Dim Table2'[columnY], ... ),
[Average Measure]
)
Thank you so much it works.
But the summation is not correct for integer
Suppose - 7% +0% total showing -8% which is not correct.
But in decimal it shows correct
7.28%+0.33%=7.61%.
I want it as integer so value should be 7%. Round function not working for percentage.
Round(sumx(),avg measure),0).
Use
VALUES ( 'Table'[the slicing by column at rows of the matrix] ),
ROUND ( [Average Measure], 0 )
)
I tried it already round(avg measure) gives 0% individual value and sum becomes 0%.this does not work. Is there any other way to achieve it?
You wrapped the whole SUMX with ROUND. You need to wrap only the measure inside SUMX
SUMX (
VALUES ( 'Table'[the slicing by column at rows of the matrix] ),
ROUND ( [Average Measure], 0 )
)
I did the way you mentioned above.Wrapped round function inside sumx not whole sumx. That did not work. It rounds each avg measure value to 0%
Please provide a screenshot for better understanding of your problem
User | Count |
---|---|
59 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |