topic Re: DAX for measure -Sum with condition in DAX Commands and Tips

DAX for measure -Sum with condition

Anonymous — Tue, 17 Aug 2021 14:58:52 GMT

Hi PBI experts

I am unable to write DAX for below scenario.

In given Data table, measure to find out sum of qty where at least one of Com typ is C for each ID

Result- 555

Thanks

Radhika2605 — Tue, 17 Aug 2021 15:47:23 GMT

Hi Anonymous,

You can use the following DAX function -

Sum Of Quantity = CALCULATE( SUM ('Table'[Qty]), FILTER ('Table', 'Table'[Com typ]) = 'C' )

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

Thanks

Radhika

Anonymous — Tue, 17 Aug 2021 16:42:09 GMT

Thanks for reply but this DAX will filter C and sum of only those qty

I need sum of all the rows (Qty) for IDs which have com typ as C. In above data except ID 382991 all others have C so, result as 555.

Radhika2605 — Wed, 18 Aug 2021 09:19:19 GMT

amitchandak Sorry to tag you like that but saw your replies on various queries so thought you might be the right person. Any ideas about this one?

Thanks

Radhika