Forum Discussion

mafioso's avatar
mafioso
Helper II
8 years ago

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 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!

Need Help

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    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

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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