Guitarmageddon
Board Regular
- Joined
- Dec 22, 2014
- Messages
- 161
Hey folks, super simple one here but Im slipping up somewhere.
I had originally thought I wanted to COUNTA based on counting all the values of "NEW" in my field labeled [ACTION]. However I need to count all the values of NEW or OPEN.
How do I modify the original to include both those criteria?
=CALCULATE(COUNTA('REPORT'[ACTION]),'REPORT'[ACTION]="NEW")
I tried nesting them inside one large OR function, but that just returned true/false values and messed with the context of my pivot table.
For example:
=OR(CALCULATE(COUNTA('REPORT'[ACTION]),'REPORT'[ACTION]="NEW"),CALCULATE(COUNTA('REPORT'[ACTION]),'REPORT'[ACTION]="OPEN"))
Im thinking I should be able to use the OR operator of " || " somewhere in the original cant I?
I had originally thought I wanted to COUNTA based on counting all the values of "NEW" in my field labeled [ACTION]. However I need to count all the values of NEW or OPEN.
How do I modify the original to include both those criteria?
=CALCULATE(COUNTA('REPORT'[ACTION]),'REPORT'[ACTION]="NEW")
I tried nesting them inside one large OR function, but that just returned true/false values and messed with the context of my pivot table.
For example:
=OR(CALCULATE(COUNTA('REPORT'[ACTION]),'REPORT'[ACTION]="NEW"),CALCULATE(COUNTA('REPORT'[ACTION]),'REPORT'[ACTION]="OPEN"))
Im thinking I should be able to use the OR operator of " || " somewhere in the original cant I?
Last edited:
