Forum Discussion

alhowarth's avatar
alhowarth
Icon for Helper I rankHelper I
6 years ago
Solved

Line chart for success vs failures, and DAX help

I am working with scheduled-jobs data.  I would like to create a chart to show the number of success and failures per day. I'm thinking that this would be a line chart, with one line for success and...
Need Help
  • lit2018pbi's avatar
    lit2018pbi
    6 years ago

    alhowarth 

     

    Here is my Data set: On August 28 and August 29 there are 2 counts.

     

    RUN_DTExit_code

    8/27/20200
    8/28/20200
    8/28/20201
    8/28/20201
    8/29/20200
    8/29/20200
    8/29/20201
    8/30/20200
    8/30/20201

     

    I have used the following measures:

    Success = CALCULATE(COUNT('Table'[Exit_code]),'Table'[Exit_code]=0)
    Failure = CALCULATE(COUNT('Table'[Exit_code]),'Table'[Exit_code]=1)
     
    Here's the final visual:
     
     
    Let me know if this resolves your issue.
lit2018pbi's avatar
lit2018pbi
Icon for Resolver II rankResolver II
6 years ago

alhowarth 

 

Based on the screenshot you have provided may be the following is what you are looking for:

Failure = CALCULATE(SUM('Table'[Daily_count]),'Table'[Exit_code]=0)
Success = CALCULATE(SUM('Table'[Daily_count]),'Table'[Exit_code]=1)

  • alhowarth's avatar
    alhowarth
    Icon for Helper I rankHelper I
    6 years ago

    Your screenshot is exactly what I want to see.

     

    I had to switch the values at the end as 0 is success, and 1 is failure.  Yet my success line is flat.

    Daily_Failure = CALCULATE(SUM('table'[EXIT_CODE])|'table'[Exit_code]=1)
    Daily_Success = CALCULATE(SUM('table'[EXIT_CODE])|'table'[EXIT_CODE]=0)