Forum Discussion
mafioso
8 years agoHelper II
Power BI Measure Calculation not working properly
I have this measure: Test =
CALCULATE(
[M_EBIT Prod_AfA];
FILTER(
ALL('Master'[Date]);
ISONORAFTER('Master'[Date]; MIN('Master'[Date]); DESC)
)
) I know that MIN causes the problem b...
TomMartens
8 years agoSuper User
Hey,
I'm not totally sure if I totally understand your requirement.
A measure always returns scalar value, meaning just one value.
I'm not sure what you mean by "there are two values in the table"
- two rows in your fact table with different values for the [M_EBIT Prod_Afa] on the MIN date
and I'm also not sure what you want as a result.
Regards
Tom