Convert ATTR function in Tableau into POWER BI Dax

[rasalaprashanth]

Hello All, 

I have a Requirement to convert one of the Tableau measure into POWER BI
Here is the sample data

AMD/Maintenance Breakdown	Order	Total Budget	End Balance	YearEndBal%
-	10	446,503,293.64	2,364,093.83	1%
-	11	204,933,167.69	3,572,690.02	2%
-	12	184,531,931.08	1,356,964.57	1%
-	13	112,299,403.30	72,038.66	0%
-	14	247,470,847.52	366,903.26	0%
-	15	240,322,600.03	5,271,320.47	2%
-	16	172,902,845.99	11,137,559.92	6%
-	17	123,905,346.46	2,694,211.07	2%
-	18	150,437,488.48	2,426,004.90	2%
-	19	323,886,636.99	86,004.21	0%
Equipment	10	106,192,470.67	10,458,573.15	10%
General	10	68,978,615.45	13,102,609.69	19%
Reserves	10	27,723,063.64	27,723,063.64	100%

Calculation for YearEndBal% = SUM(End Balance)/SUM([Total Budget]) ( replicated in POWER BI )

Now my requirement is to replicate the below measure from Tableau to POWER 

YearEndBalnceASP%= CASE ATTR([AMD/Maintenance Breakdown]) WHEN "Reserves" THEN NULL
WHEN "Equipment" THEN NULL
ELSE SUM([Year End Balance (w.Approved Spend Plan)])/SUM([Total Budget])
END

AMD/Maintenance Breakdown	Order	Total Budget	End Balance	YearEndBalnceASP%
-	10	446,503,293.64	2,364,093.83	1%
-	11	204,933,167.69	3,572,690.02	2%
-	12	184,531,931.08	1,356,964.57	1%
-	13	112,299,403.30	72,038.66	0%
-	14	247,470,847.52	366,903.26	0%
-	15	240,322,600.03	5,271,320.47	2%
-	16	172,902,845.99	11,137,559.92	6%
-	17	123,905,346.46	2,694,211.07	2%
-	18	150,437,488.48	2,426,004.90	2%
-	19	323,886,636.99	86,004.21	0%
Equipment	10	106,192,470.67	10,458,573.15
General	10	68,978,615.45	13,102,609.69	19%
Reserves	10	27,723,063.64	27,723,063.64

[amitchandak]

@rasalaprashanth , refer if this can help

Tableau Vs Power BI- Chapter 21: Tableau ATTR: https://www.youtube.com/watch?v=6mXMPX7S8oU&list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54&index=21