convert value of count to percentage per month

[bdino]

Hi, please help to convert the value of count to percentage per month on my below table 

here's  my sample data

[FarhanAhmed]

Try this 

% Count = COUNT(Table[Has Breached]) / CALCULATE(COUNT(Table[Has Breached]),ALLSELECTED(Table))

Make sure that you change the  formatting of measure to Percentage 

[amitchandak]

@bdino , Try measures like

Breached % =Divide(calculate(countrow(Table), Table[Breached]= True()),calculate(countrow(Table)))
Not Breached % =Divide(calculate(countrow(Table), Table[Breached]= False()),calculate(countrow(Table)))

At you using threshold as 85. You have multiple above100

[bdino]

syntax error The syntax for 'Table' is incorrect. (DAX(Divide(calculate(countrows(Table), Table[has Breached]= True()),calculate(countrows(Table))))).

[ryan_mayu · Accepted solution]

@bdino 

Please try this

Measure = COUNTROWS('Table (2)')/CALCULATE(COUNTROWS('Table (2)'),ALLEXCEPT('Table (2)','Table (2)'[Resolved],'Table (2)'[Has breached]))

Since, you only show the year and month in the resolved column , I am not sure if the day values are the same. If not the same.

you can create a new column

new resolved = year('Table (2)'[Resolved])&month('Table (2)'[Resolved])

then create measure

Measure 2 = 
COUNTROWS('Table (2)')/CALCULATE(COUNTROWS('Table (2)'),ALLEXCEPT('Table (2)','Table (2)'[new resolved]))

[bdino]

Hi ryan_mayu Thanks! issue resolve..