Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help on DAX expression

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  %C...
  • rbriga's avatar
    rbriga
    5 years ago

    Please try: 

    % Complete =(
   (
        COUNTROWS(
            FILTER(
              'DATA',
                DATA[Completion Status] IN
{"Complete", "Incomplete"}
            )
        ) /( COUNTROWS( 'DATA' ) )
    )
)
rbriga's avatar
rbriga
Icon for Impactful Individual rankImpactful Individual
5 years ago

Please try: 

% Complete =(
   (
        COUNTROWS(
            FILTER(
              'DATA',
                DATA[Completion Status] IN
{"Complete", "Incomplete"}
            )
        ) /( COUNTROWS( 'DATA' ) )
    )
)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Great, It worked.  

Gopal, Hyderabad India.