topic Re: How to add more filter on this measure in DAX Commands and Tips

How to add more filter on this measure

JustinDoh1 — Mon, 04 Jul 2022 06:15:59 GMT

I am trying to add more filter on the bottom measure:

Bottom measure is working fine, but I would like to add more criteria:

Revenue =

sumx(

values(TableA[AMOUNT]),

Calculate(

SELECTEDVALUE

(

'TableA'[AMOUNT]

),

(

'TableA'[CLASSID] = "114"

)

)

)

Modified version - I would like to add more criteria (something like in bold ) :

Revenue =

sumx(

values(TableA[AMOUNT]),

Calculate(

SELECTEDVALUE

(

'TableA'[AMOUNT]

),

(

'TableA'[CLASSID] = "114"

'TableA'([ACCOUNTNO]) in ('4', '5') ?

/// in SQL: [ACCOUNTNO] in ('4', '5')

)

)

)

Thanks.

Re: How to add more filter on this measure

tamerj1 — Mon, 04 Jul 2022 07:24:08 GMT

JustinDoh1

Please try

Revenue = SUMX ( VALUES ( TableA[AMOUNT] ), CALCULATE ( SELECTEDVALUE ( 'TableA'[AMOUNT] ), 'TableA'[CLASSID] = "114", 'TableA'[ACCOUNTNO] IN { "4", "5" } ) )