DAX filter problems

jmcph , This should work. what is the wrong you are getting? You should also get a row for Ref102.

try measure like

Sumx (filter(Table,[Book] = "Eco"), Table[Amt])
Sumx (filter(Table,[Book] = "Pro"), Table[Amt])

Hi, jmcph 

You may create measures as below. The pbix file is attached in the end.

EcoAmt = 
CALCULATE(
    SUM('Table'[Amt]),
    FILTER(
        'Table',
        [Book]="Eco"
    )
) 

ProAmt = 
CALCULATE(
    SUM('Table'[Amt]),
    FILTER(
        'Table',
        [Book]="Pro"
    )
) 

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly