0
votes

I have calculated two measures:

MetalProduction = sum(IXMBalanceSheet[Metal_production])

MetalProductionLastYr = calculate([MetalProduction],dateadd('Date'[Date],-1,YEAR))

then calculated the difference between these measures for absolute change:

ABS Production Chg = [MetalProduction] - [MetalProductionLastYr]

Now while maintaining the filter context in power bi, I would like to sum the ABS Production chg where it is greater than zero.

How would this measure be compiled?

1

1 Answers

0
votes

Here some simply example:

GreaterThanZero =
CALCULATE (
    [ABS Production Chg],
    FILTER ( 'IXMBalanceSheet', VAR __temp = [ABS Production Chg] RETURN __temp > 0 )
)

enter image description here