Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Can some one help me to get the sum of the measure number that i have created. At an ro level i want to show if the particular account is earning more than 10% then 1 else 0.
The same formula apply to the total as well. So basically i don't want the same to be applied. i just need to do the total of all the values in the column i.e Advisory SLI (1+1=2).
Regards,
Ranjan
Solved! Go to Solution.
Try Like
sumx(summarize('Table','Table'[Account],"_acc",[Advisory %]),if ([_acc]>0.1,1,0))
Appreciate your Kudos.
Try Like
sumx(summarize('Table','Table'[Account],"_acc",[Advisory %]),if ([_acc]>0.1,1,0))
Appreciate your Kudos.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |