Calculated Column aka Sumifs

[Anonymous]

Hello,

Below is the sample data I have. What I want to achieve is to create a calculated column that will give me the "Expected Value". However, what I am getting you can see in the column "Current Result".

My formula is:

CALCULATE(SUM(Diagonal[Value]),

Diagonal[Executable In]="M+1")

I have also tried:

CALCULATE(SUM(Diagonal[Value]),

filter(all(Diagonal),

Diagonal[Executable In]="M+1")) 

But none of the above give me the expected result.

Country	Period	Executable In	Value	Expected Value	Current Result
Wonderland	January	M+1	500	800	500
Wonderland	January	M+1	300	800	300

Can someone help here? 

thank you

Marek

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Could you tell me whether Jihwan Kim's  solution  is useful if you are creating a Calculated column not a Measure?

I made a demo for reference. If it does not meet your requirements, please provide more information for testing.

Best Regards,
Community Support Team _ Eason

[Jihwan_Kim]

Hi, @Anonymous 

I think your second trial is giving the result that you want.

you can also try the below.

CALCULATE(SUM(Diagonal[Value]),

filter(Diagonal,

Diagonal[Executable In]="M+1"))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/