cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## 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],
"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

Accepted Solutions
Super User

## Re: Help with Calculated Table - I need to filter

try this:

```SBU Sold GBL CIS Intra =
FILTER (
SELECTCOLUMNS (
'1 Sold',
"Selling SBU", "GBL CIS",
"Interco", '1 Sold'[InterCo],
"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
)```

Super User

## Re: Help with Calculated Table - I need to filter

try this:

```SBU Sold GBL CIS Intra =
FILTER (
SELECTCOLUMNS (
'1 Sold',
"Selling SBU", "GBL CIS",
"Interco", '1 Sold'[InterCo],