Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
I am trying to calculate the colum i.e CALCULATED COLUMN. I want to add the percentages from different columns and divide it by the number of values as shown below using the dax expression.
What i am trying to calculate is shown in the CALCULATED COLUMN.
Can anyone help me on this?
id | WO | CUT | TOUGHEN | WASH | POLISH | DISPATCH | CALCULATED COULMN |
1 | 40% | 50% | 60% | =(40+50+60)/3 | |||
2 | 70% | 80% | =(70+80)/2 | ||||
3 | 10% | 20% | 30% | 40% | 50% | =(10+20+30+40+50)/5 | |
4 | 20% | 30% | 50% | 70% | 0% | 0% | =(20+30+50+70)/6 |
Solved! Go to Solution.
Hi @shivar ,You can use the following DAX for the calculated column
CALCULATED COLUMN =
Hi @shivar ,You can use the following DAX for the calculated column
CALCULATED COLUMN =
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |