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%
Go to Solution.
% Complete =(
DATA[Completion Status] IN
) /( COUNTROWS( 'DATA' ) )
View solution in original post
Great, It worked.
Gopal, Hyderabad India.
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!