Filter for multiple values in one cell

Dear tamerj1 You are really been my inspiration and support over the past 2 weeks. Thank you.
Thank you for the DAX. 
Based on your previous DAX, this is what I used and it returns the same result. Only thing I didn't add was the +0 at the end of the DAX so that my card visual displays a 0 instead of the word blank 🙂

Good Morning tamerj1 It must be whole numbers. Apologies for the oversight.

Hello tamerj1 I replaced SUM( ('Table'[BE Key]) ),with SUM( ('Table'[BE Size]) ), and the visual responds with exactly what I needed. Thank you soo much for assisting me in this regard. Bless You.

Hello tamerj1 Absolutely no reason for apologies. Through your support, I have learnt how to read some of the DAX and edit them to make them work 🙂 Once again thank you for your assistance provided. 

KubenM 

Count of BE With Epic =
COUNTROWS (
FILTER (
'Table',
VAR SelectedValues =
VALUES ( FilterTable[Item Value] )
VAR String = 'Table'[Fixed Version]
VAR Items =
SUBSTITUTE ( String, ", ", "|" )
VAR Length =
COALESCE ( PATHLENGTH ( Items ), 1 )
VAR T1 =
GENERATESERIES ( 1, Length, 1 )
VAR T2 =
SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )
RETURN
NOT ISEMPTY ( INTERSECT ( T2, SelectedValues ) )
&& 'Table'[BE Without Epic] = BLANK ()
)
) + 0

KubenM 

This looks like a text data type 

KubenM 
Have you tried?

BE Size =
CALCULATE (
    SUM ( 'Table'[BE Key] ),
    FILTER (
        'Table',
        VAR SelectedValues =
            VALUES ( FilterTable[Item Value] )
        VAR String = 'Table'[Fixed Version]
        VAR Items =
            SUBSTITUTE ( String, ", ", "|" )
        VAR Length =
            COALESCE ( PATHLENGTH ( Items ), 1 )
        VAR T1 =
            GENERATESERIES ( 1, Length, 1 )
        VAR T2 =
            SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )
        RETURN
            NOT ISEMPTY ( INTERSECT ( T2, SelectedValues ) ) && 'Table'[BE Size]
    )
) + 0

KubenM 
Small typo mistake

Hello tamerj1 

Here’s my last query on the report I am building 😊

Based on the DAX filter you so generously built for me, how do I add the following DAX to it:

BE Without Epics = COUNTBLANK('Table'[BE Without Epic])+0

1. In the data Table I added a column called “BE Without Epic” and in the column fields I entered 1 for where a BE has an Epic and left a Blank for the BE (APO – 4) that does not have an Epic.
2. My card visual shows a 1 based on my simple COUNTBLANK DAX.

• When I filter on Y23PI1 or Y23PI2 or Y23PI3 or Y23PI4 the card must return 0.
• When I remove the filter selections or select F23PI5, the card must return 1.

Hello tamerj1  Trust that you well. Not sure if I should create a brand new entry or keep my next question in this current response flow.

I am trying to edit the original DAX you created for me to include a new column called BE Size and the visual is only returning the count of BE and not showing the sum of the Story Points per BE size. See information I used below to inform my challenge.

Sum of BE Size

Table

FilterTable

DAX

Count of BE Size =

CALCULATE (

COUNTROWS ( VALUES ( 'Table'[BE Key] ) ),

FILTER (

'Table',

VAR SelectedValues =

VALUES ( FilterTable[Item Value] )

VAR String = 'Table'[Fixed Version]

VAR Items =

SUBSTITUTE ( String, ", ", "|" )

VAR Length =

COALESCE ( PATHLENGTH ( Items ), 1 )

VAR T1 =

GENERATESERIES ( 1, Length, 1 )

VAR T2 =

SELECTCOLUMNS ( T1, "@Item", PATHITEM ( Items, [Value] ) )

RETURN

NOT ISEMPTY ( INTERSECT ( T2, SelectedValues ) ) && 'Table'[BE Size]

))+0

Visual

How do I refine the DAX so that the Visual displays the Data Labels as Count of Size ie, 100 or 200 and the Total Labels to show size ie. 100 or 200, etc?

Note: The current visual isn’t reflecting the correct count.

Y23PI1 should show a stacked bar of 100 and 200 and the total label to show 300.

Y23PI2 should show a stacked bar of 200 and the total label to show 200

Y23PI3 should show a stacked bar of 200 and a total label of 200

Y23PI4 should show a stacked bar of 100 and a total label of 100

Y23PI5 should show a stacked bar of 250 and a total label of 250

Hello tamerj1 Even with changing the format of the column from text to whole numbers, I have no idea how to edit your original DAX to show the sum of Story Points Per each BE Size.
Please help. Thank you.

Hello tamerj1 I created the New Measure and dragged it onto a new page for Power BI to select a suitable visual and I get an error.  Please assist.

KubenM 
Apologies. was just a typo mistake.