Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
will appreciate it if somebody points out the error in my calculation. I need to calculate the % of each bin. My calculation is giving me 100% per bin.
Solved! Go to Solution.
@xariet , for % of total you should try like
% of bin = divide([Number of borrowere], CALCULATE([Number of borrowere], allselected()))
or
% of bin = divide([Number of borrowere], CALCULATE([Number of borrowere], all()))
@xariet , for % of total you should try like
% of bin = divide([Number of borrowere], CALCULATE([Number of borrowere], allselected()))
or
% of bin = divide([Number of borrowere], CALCULATE([Number of borrowere], all()))
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |