Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
I have a Table, DATA in which there is a column 'Completion Status', that has four values - Complete, Incomplete, Overdue, Retraining Overdue.
I could calculate the %Complete using
%Complete = ((COUNTROWS(FILTER('DATA',DATA[Completion Status]="Complete"))/(COUNTROWS('DATA'))))
Now I want to calcuate %compliance by adding one more value - Incomplete.
Essentially, this need to calculate Complete+Incomplete/All 4 values of the Column%
Kindly help
Gopal
Hyderabad
Solved! Go to Solution.
Please try:
% Complete =( ( COUNTROWS( FILTER( 'DATA', DATA[Completion Status] IN {"Complete", "Incomplete"} ) ) /( COUNTROWS( 'DATA' ) ) ) )
Please try:
% Complete =( ( COUNTROWS( FILTER( 'DATA', DATA[Completion Status] IN {"Complete", "Incomplete"} ) ) /( COUNTROWS( 'DATA' ) ) ) )
Great, It worked.
Gopal, Hyderabad India.
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |