Forum Discussion
DAX not running%
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( ...
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.
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.can you provide demo file?
would it be okay to provide some measure instead of a file? sorry
Im using table as my visualisations
