Row sum in matrix with boolean value

Hi， Anonymous ；

You could create a measure by ISINSCOPE() AND HASONEVALUE().

Measure = IF(HASONEVALUE('Table'[Date])&&ISINSCOPE('Table'[name]), IF(SUM([value])>0,1,0),SUM('Table'[value]))

The final output is shown below:

If this formula does not apply to your data, can you share a simple example similar to your original table structure and the result you want to output?

Looking forward to your reply！

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.