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 

%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

  • rbriga's avatar
    rbriga
    5 years ago

    Please try: 

    % Complete =(
   (
        COUNTROWS(
            FILTER(
              'DATA',
                DATA[Completion Status] IN
{"Complete", "Incomplete"}
            )
        ) /( COUNTROWS( 'DATA' ) )
    )
)

2 Replies

  • 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.