cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andshepch Regular Visitor
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],
"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

Accepted Solutions
Highlighted
Super User
Super User

Re: Help with Calculated Table - I need to filter

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
)

 

1 REPLY 1
Highlighted
Super User
Super User

Re: Help with Calculated Table - I need to filter

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
)