Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
rbriga
Impactful Individual
Impactful Individual

Please try: 

% Complete =(
   (
        COUNTROWS(
            FILTER(
              'DATA',
                DATA[Completion Status] IN
{"Complete", "Incomplete"}
            )
        ) /( COUNTROWS( 'DATA' ) )
    )
)
-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

View solution in original post

2 REPLIES 2
rbriga
Impactful Individual
Impactful Individual

Please try: 

% Complete =(
   (
        COUNTROWS(
            FILTER(
              'DATA',
                DATA[Completion Status] IN
{"Complete", "Incomplete"}
            )
        ) /( COUNTROWS( 'DATA' ) )
    )
)
-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!
Anonymous
Not applicable

Great, It worked.  

Gopal, Hyderabad India.  

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors