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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Andshepch
Advocate II
Advocate II

Help with Calculated Table - I need to filter

Hi all,

 

I have a calculated table using the following formula:

 

SBU Sold GBL CIS Intra = SELECTCOLUMNS('1 Sold',"Selling SBU","GBL CIS",
"Interco",'1 Sold'[InterCo],
"Business Priority Offer",'1 Sold'[Business Priority Offer],
"P&C",'1 Sold'[P&C],
"Cloud/Cyber",'1 Sold'[Cloud/Cyber],
"Sales Stage Date",'1 Sold'[Sales Stage Date],
"Sold CV €M",'1 Sold'[CV €M],
"Sold CM €M",'1 Sold'[CM €M])

and all I need to do is make the calculated table only include rows wher the field '1 Sold'[InterCo] contains the text "intra". I know it's probably simple, but I can't work out how to do it. Can you please help?

 

Thank you

 

Andrew

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @Andshepch 

try this:

SBU Sold GBL CIS Intra =
FILTER (
    SELECTCOLUMNS (
        '1 Sold',
        "Selling SBU", "GBL CIS",
        "Interco", '1 Sold'[InterCo],
        "Business Priority Offer", '1 Sold'[Business Priority Offer],
        "P&C", '1 Sold'[P&C],
        "Cloud/Cyber", '1 Sold'[Cloud/Cyber],
        "Sales Stage Date", '1 Sold'[Sales Stage Date],
        "Sold CV €M", '1 Sold'[CV €M],
        "Sold CM €M", '1 Sold'[CM €M]
    ),
    FIND ( [Interco], "intra", 1, 0 ) > 0
)

 

View solution in original post

1 REPLY 1
AlB
Super User
Super User

Hi @Andshepch 

try this:

SBU Sold GBL CIS Intra =
FILTER (
    SELECTCOLUMNS (
        '1 Sold',
        "Selling SBU", "GBL CIS",
        "Interco", '1 Sold'[InterCo],
        "Business Priority Offer", '1 Sold'[Business Priority Offer],
        "P&C", '1 Sold'[P&C],
        "Cloud/Cyber", '1 Sold'[Cloud/Cyber],
        "Sales Stage Date", '1 Sold'[Sales Stage Date],
        "Sold CV €M", '1 Sold'[CV €M],
        "Sold CM €M", '1 Sold'[CM €M]
    ),
    FIND ( [Interco], "intra", 1, 0 ) > 0
)

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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