Sum if Product Type="MRC", but Product Type is in a Related Table

DAX DAX Calculations
6

@ScottTPA,

I think you were super close on this one – probably only one line of DAX away from the solution. The key is removing the filter on Product ID, so that the delta computed in total by Name. Here’s the revised measure:

Total MRC Delta Neg Only = 

VAR Delta =
CALCULATE(
    [MRC Revenue Inc/(Dec) vs Prior Month],
    REMOVEFILTERS( 'Product'[ID] )
)

RETURN
IF(
    Delta < 0,
    [MRC Revenue Inc/(Dec) vs Prior Month],
    BLANK()
)

image
image.png743×415 14.2 KB

Full solution file posted below.

1 Like