Forum Discussion

ePros's avatar
ePros
Frequent Visitor
3 years ago
Solved

Create Expression counting a single column but using various qualifying criteria

Is there a way to write an Expression to calculate the total from "report (1) column (3) with criteria (a) AND report (1) column (3) with criteria (b) "What I am trying to do is count the number of c...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    ePros 

    pls try this

    Measure = countx(FILTER('Table','Table'[Source]="Referral"&&'Table'[Call Duration]>30 ||'Table'[Source]="Commercial"&& 'Table'[Call Duration]>15||'Table'[Source]="Advertisement"&&'Table'[Call Duration]>5),'Table'[Calls])

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

ePros 

pls try this

Measure = countx(FILTER('Table','Table'[Source]="Referral"&&'Table'[Call Duration]>30 ||'Table'[Source]="Commercial"&& 'Table'[Call Duration]>15||'Table'[Source]="Advertisement"&&'Table'[Call Duration]>5),'Table'[Calls])

ePros's avatar
ePros
Frequent Visitor
3 years ago

Thank you that worked well. Obviously that was not the data I was working with but I was to get a single total of the data where each line was tested for 3 conditions to determine if counted and each condition verified data from 3 separate columns. I was considering returning to the table and adding a column and using IF statements then just adding from there., I appreciate the help.