Conditional Sum Measure

[Anonymous]

Hello  — I am looking to create a measure that is a conditional sum of another measure in a matrix.

In this example, I am trying to see these highlighted values summed in an additional column because they are >= 10.

I would appreciate the help!

Here is a link to the file: https://drive.google.com/file/d/1-irod6Ha-sDAIYStKb77zuv6uNqlG08x/view?usp=sharing

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please try:

Measure = SUMX(FILTER(SUMMARIZE('Audit',Audit[code],Audit[master_key],Audit[trans_date],"Minutes",[Minutes between Postings]),[Minutes]>10),[Minutes])

Final output:

Best Regards,

Jianbo Li

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