Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to Solution.
Try this
NewMeasure =
CALCULATE (
COUNTROWS ( TableName ),
CONTAINSSTRING ( TableName[ID], "CHG" ),
TableName[Status] = "Scheduled"
)
Try this
NewMeasure =
CALCULATE (
COUNTROWS ( TableName ),
CONTAINSSTRING ( TableName[ID], "CHG" ),
TableName[Status] = "Scheduled"
)
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |