Need help in writing DAX Measure

[manojk_pbi]

Hi Friends,

I have below data, using it i need to show what's the percentage of published task out of total tasks. Pls advice how can we do this both in KPI chart and in table.

% of Published Tasks = Tasks with publish status / all tasks excluding Delete & withdrwl

Col1	Col2
Task1	Publish
Task2	Draft
Task3	WIP
Task4	Deleted
Task5	Deleted
Task6	Withdrwl
Task7	Publish
Task8	Publish
Task9	Publish
Task10	Draft
Task11	New
Task12	New

[v-sdhruv]

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.