DAX query

Hi  Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Count Funded Project Approval by Approving Person =
var _table=
SUMMARIZE(
    'Table','Table'[Team Member])
var _table2=
ADDCOLUMNS(
    _table,"1",
    COUNTX(
        FILTER('Table',
        'Table'[Approving Person]=EARLIER([Team Member])&&[Current Status]="Funded"),[Current Status]))
var _value=
MAXX(
    FILTER(_table2,[Team Member]=EARLIER('Table'[Team Member])),[1])
return
IF(
    _value=BLANK(),0,_value)

Project Count by Team Member=
CALCULATE(
    DISTINCTCOUNT('Table'[Team Member]))

2. Result:

Best Regards,

Liu Yang

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