How Can I Repeat this function in Power BI DAX?

[VBE313]

I am trying to filter the same column twice by getting a unique value. How can i do this in Power BI?

Platform	FY21 Shipped thru Prev Month	MAR Total	MAR Shipped	Past Due	MAR Backlog	APR Backlog	MAY Backlog	JUN Backlog	JUL Backlog	Future Backlog
External Sales Orders	$ 773,399.75	$ 260,987.55	$ -	$ 152,168.10	$ 108,819.45	$ 232,762.00	$ 232,762.00	$ -	$ -	$ -
Internal Sales Orders	$ 812,227.18	$ 818,383.81	$ 4,573.28	$ 463,233.50	$ 350,577.03	$ 438,971.35	$ 319,797.36	$ 149,585.29	$ -	$ -
MSR (Internal)	$ 348,055.74	$ 123,708.64	$ 5,703.13	$ 17,321.90	$ 100,683.61	$ 129,652.55	$ -	$ 15,294.84	$ -	$ -
Batch (Internal T&M)	$ 86,106.21	$ 5,703.13	$ 5,703.13	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Total External	$ 773,399.75	$ 260,987.55	$ -	$ 152,168.10	$ 108,819.45	$ 232,762.00	$ 232,762.00	$ -	$ -	$ -
Total Internal	$ 1,246,389.13	$ 947,795.58	$ 15,979.54	$ 480,555.40	$ 451,260.64	$ 568,623.90	$ 319,797.36	$ 164,880.13	$ -	$ -
Business Plan External Customers	$ 930,095.52		$ 299,002.34	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Business Plan Internal Customers	$ 749,391.14		$ 260,447.64	$ -	$ -	$ -	$ -	$ -	$ -	$ -

 

[ggirf14]

1- You are asking to filter a column twice?
by getting a unique value?
I have no clue what you are asking.
Could you rephrase?

2- Your formula is showing that you are trying to add what is in column B based on partial match of rows of column A.
How is this relevant to a question about filters?

 

[ggirf14]

I have often spend hours to clarify a question on this board. 1/2 the time I found myself the solution making the example as simple as possible before posting it.
Not often I provided help and I feel it would be my turn to help, this seemed an easy one (Filters and / or SUMIFS) ... I just dont understand the question.

 

[VBE313]

No you were right the information I gave didn't make sense. I actually ended up figuring it out though so I decided to just mark your answer as a solution.

FILTER(WaterfallTable,[Platform] = "Business Plan External Customers" || [Platform] = "Business Plan Internal Customers")

This really wasn't a solution to my question though since in my Excel formula I am looking for a key word. So @ggirf14 , How can I change the following code above to just find "Business Plan*" as a keyword?

 

[ggirf14]

From Power Query in Excel I used the GUI to get the following formula
= Table.SelectRows(#"Promoted Headers", each Text.Contains([Platform], "Business Plan"))