Making Column with static measure-value but only for specific rows

[Anonymous]

Hi everyone!

I'm having some problem, with writing formula.

I have this in matrix:

Where Company and Week/Year are Columns, that cant be pivoted, and Value is some Measure:

BIAS_W_12 = IFERROR((SUM('DPA BIAS'[Final CDP W-12])-SUM('DPA BIAS'[Order Quantity]))/SUM('DPA BIAS'[Final CDP W-12])*100;0)

I want to make a Column for every of this weeks where i will have a value of a measure, when week is ok, 0 otherwise.

Can you help me how to do it?

I'm stuck for a few hours now.

Thank You

Radkos

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may try the following pattern.

Measure =
VAR w = SELECTEDVALUE ( Table1[Week/Year] ) RETURN IF ( w = 12, 1, 0 )