Need help in writing DAX Measure

Hi manojk_pbi ,
You can try this measure:

% Published Tasks =
DIVIDE(
CALCULATE(COUNTROWS(Data), Data[Col2] = "Publish"),
CALCULATE(COUNTROWS(Data), NOT(Data[Col2] IN {"Deleted", "Withdrwl"}))
)
Hope this helps!
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank you.

Hi manojk_pbi ,

You can try this-
ValidPg% =
DIVIDE(
CALCULATE(
COUNTROWS(Data),
NOT(ISBLANK(Data[Pdate])),
Data[ReviewDt] <= TODAY()
),
CALCULATE(
COUNTROWS(Data),
NOT(ISBLANK(Data[Pdate])),
NOT(Data[Pstatus] IN {"Deleted", "Withdrawn"})
)
)
Hope this helps!