DAX not running%

[tonyc]

I have CY% in a measure. For some reason my CY% is a running %.

How do I make CY% is not a running %?

Here is DAX in CY% 

A WEIGHT CY =

CALCULATE(

    [A WEIGHT%] ,

    DATEADD(

        'Date'[Date],

        0,

        YEAR

    )

Key	CY%			Key	CY%
A	12			A	39
B	13			B	39
C	14			C	39
TOTAL	39

Thanks

[rubayatyasmin]

Hey, @tonyc 

use ALL function. For example:

A WEIGHT CY =
CALCULATE(
[A WEIGHT%],
FILTER(
ALL('Date'),
'Date'[Year] = MAX('Date'[Year])
)
)

this should remove filters if any. 

[tonyc]

No.. it didn't work.  I still get the running total.

Let's try a different approach.  I want to calculate the Result% column using a measure.

This is what I am expecting -

Key	Z1%	Z2%	Result %
A	20%	80%	0.206793
B	30%	70%	0.181431
C	10%	90%	0.232156

A - 0.206793 = (20/100* 0.0038935516)+(80/100 * 0.2575179612)

B  - 0.181431 - (30/100* 0.0038935516)+(70/100 * 0.2575179612)

0.0038935516 and 0.2575179612 are generated from the measure and I want all calculations using these 2 constants variable

Type 1 Weight	Type 2 Weight
0.003894	0.257518

Here is my measure for Result%

Result % =

 ( [Z1%] * [Type 1 Weight]) +  ( [Z2%] * Type 2 Weight )

Thank you.. let me know if you want more information.

[rubayatyasmin]

can you provide demo file?

[tonyc]

would it be okay to provide some measure instead of a file? sorry 

Im using table as my visualisations

[rubayatyasmin]

demo data with requiremnts on would be perfect

[tonyc]

I want 0.13% to be displayed in the Weight column with repetition.  thanks

[Ashish_Mathur]

Share the download link of the PBI file.