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.
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
6 years ago

Hi, alhowarth , based on your description, a DAX equivalent of your sql would be like this,

=
SUMMARIZECOLUMNS (
    'Table'[RUN_DT],
    'Table'[EXIT_CODE],
    "Daily_Count", CALCULATE ( COUNTROWS ( FILTER ( 'Table', 'Table'[EXIT_CODE] <> 0 ) ) )
)

 

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

    I received the dreaded error: The Expression Refers to Multiple Columns. Multiple Columns Cannot Be Converted to a Scalar Value.

    error. 
    After some Googling, I found a suggestion to use:  COUNTROWS( ).  
    Then, I was able to save the Measure without error, but it wouldn't work on my chart. 

    MdxScript(Model) (4, 54) Calculation error in measure 'table'[Measure]: SummarizeColumns() and AddMissingItems() may not be used in this context.