Caluculate Va;ues on the basis of values of other column

[siddharth_dixit]

Hi All, 

I am new to powerbi and need help in creating a dax. My data looks like:

Fiscal Year	Col 1	Col 2	Total offtake YA
FY17-18	A	ABC	533
FY17-18	A	DEF	1264
FY17-18	A	GHI	1974
FY17-18	B	ABC	1424
FY17-18	B	DEF	1677
FY17-18	B	GHI	1864
FY18-19	A	ABC	832
FY18-19	A	DEF	26
FY18-19	A	GHI	1799
FY18-19	B	ABC	736
FY18-19	B	DEF	1748
FY18-19	B	GHI	1481

Now I want to sum "Total Offtake MSU YA" only for Col2 = "ABC" and for each FY. Is it possible to store it in a measure or repeat the same value in each row corresponding to that FY?

[Nathaniel_C]

Hi @siddharth_dixit ,
Not exactly clear what you are asking for because the column header does not match the request. Total offtake YA<> sum "Total Offtake MSU YA" only for Col2 = "ABC" and for each FY. 
However if that is just a typo, then try this:
myTable is the table name I used.
Create a measure.

Sum of Total offtake YA = SUM(myTable[Total offtake YA])

Create a second measure.

Sum of ABC per FY = 
CALCULATE([Sum of Total offtake YA], ALLEXCEPT(myTable,myTable[Fiscal Year]),myTable[Col 2]= "ABC")

Apply the second measure to your visual

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel