Power BI Measure Calculation not working properly

[mafioso]

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 because I get the min value but there are TWO values in the table. Is it possible to get both? I want to filter by date and get all values. Any help would be appreciated!

[v-juanli-msft]

Hi @mafioso

I reproduce your issue with my data, could you point out what result you want?

Measure =
CALCULATE (
    SUM ( Sheet1[number] ),
    FILTER (
        ALL ( Sheet1 ),
        ISONORAFTER ( Sheet1[number], MIN ( Sheet1[number] ), ASC )
    )
)

 

Best Regards

Maggie

[TomMartens]

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