Help with Calculated Table - I need to filter

[Anonymous]

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

[AlB · Accepted solution]

Hi @Anonymous 

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
)