Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
sa34techer
Helper II
Helper II

Filter Measure by 2 columns

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"?

 

IDStatus
INC029779Closed
INC065546436Open
INC131063093Scheduled
INC196579750Closed
SCTASK004566Open
SCTASK004567Scheduled
INC020534543Closed
CHG00354333Open
INC0267456423Scheduled
SCTASK0068666Closed
CHG00348765Open
CTASK0356544Scheduled
SCTASK006564Closed
SCTASK006565Open
SCTASK006566Scheduled
CHG005634537Closed
CHG005634538Open
1 ACCEPTED SOLUTION
Gsssidhu
Frequent Visitor

Try this

 

NewMeasure =
CALCULATE (
    COUNTROWS ( TableName ),
    CONTAINSSTRING ( TableName[ID], "CHG" ),
    TableName[Status] = "Scheduled"
)

View solution in original post

1 REPLY 1
Gsssidhu
Frequent Visitor

Try this

 

NewMeasure =
CALCULATE (
    COUNTROWS ( TableName ),
    CONTAINSSTRING ( TableName[ID], "CHG" ),
    TableName[Status] = "Scheduled"
)

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.