Filter Measure by 2 columns

Question

I created a measure off the data below --> (Number# = COUNT(Table[ID])).

How to create a new measure off the Number# measure to ID column CONTAINS "CHG" and Status = "Scheduled"?

ID	Status
INC029779	Closed
INC065546436	Open
INC131063093	Scheduled
INC196579750	Closed
SCTASK004566	Open
SCTASK004567	Scheduled
INC020534543	Closed
CHG00354333	Open
INC0267456423	Scheduled
SCTASK0068666	Closed
CHG00348765	Open
CTASK0356544	Scheduled
SCTASK006564	Closed
SCTASK006565	Open
SCTASK006566	Scheduled
CHG005634537	Closed
CHG005634538	Open

gsssidhu · Accepted Answer

Try this&nbsp;NewMeasure&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;TableName&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;CONTAINSSTRING&nbsp;(&nbsp;TableName[ID],&nbsp;"CHG"&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;TableName[Status]&nbsp;=&nbsp;"Scheduled")

Forum Discussion

Filter Measure by 2 columns

1 Reply

Related content

Slicer for filtering several columns

Measure two columns

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter