Hi @harirao ,
I think you in data model [Feb-23]...[Jun-23] should all be columns as below.
This will make our calculation difficult and I suggest you to try UNPIVOT function to transform your table.
Select [Item.[DP Manager]] column and unpivot other columns. Then remove blank values in [Value] column.
For reference: Unpivot columns - Power Query | Microsoft Learn
Then average measure shoule be as below.
Count = CALCULATE(COUNT('Table'[Value]))
Percentage of Total =
VAR _Total =
CALCULATE ( [Count], ALLEXCEPT ( 'Table', 'Table'[Item.[DP Manager]]] ) )
DIVIDE ( [Count], _Total )
Result is as below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.