Forum Discussion

Frequent Visitor

4 years ago

Solved

Calculated measure with filter

Hi all, I have a sample table like this: TEST Account Amount 5000 $ 10.00 RES001 $ 15.00 5001 $ 23.00 LABOUR $ 76.00 7051 $ 168.00 5746 $ ...

4 years ago

Hi voiciK ,

Try this:

Measure = CALCULATE(SUM(TEST[Amount]),FILTER(TEST , LEFT('TEST'[ACCOUNT],1) = "5"))

Community Champion

4 years ago

Hi voiciK ,

Try this:

Measure = CALCULATE(SUM(TEST[Amount]),FILTER(TEST , LEFT('TEST'[ACCOUNT],1) = "5"))