Unable to calculate % of row

[PowerBIUserUKB]

Hello,

I'm trying to calculate the percentage value of one column compared to another one.
Here is a table that will illustrate my challenge.

When II try to achieve this in Power BI I obtain the following:

I've tried to understand if any filters could be affecting the result but I just cannot get my head around this.

All measures come from the same table.

onlyMet = SUMX(FILTER(sla,sla[SLA_MetNumber]=1),sla[SLA_MetNumber])

onlyNotMet = COUNTX(FILTER(sla,sla[SLA_MetNumber]=0),sla[SLA_MetNumber])

onlyTotal = [onlyMet] + [onlyNotMet]

Percent_SLA = CALCULATE([onlyMet] /[onlyTotal])

I'm pretty sure I'm missing something fundamental but cannot see it.

Any help would be much appreciated!

[amitchandak · Accepted solution]

@PowerBIUserUKB , Prefer using divide

like

Percent_SLA = divide([onlyMet] ,[onlyTotal])

Make it decimal with 2 decimal place and Mark as % column (in measure tool)

[amitchandak · Accepted solution]

@PowerBIUserUKB , Prefer using divide

like

Percent_SLA = divide([onlyMet] ,[onlyTotal])

Make it decimal with 2 decimal place and Mark as % column (in measure tool)

[PowerBIUserUKB · Accepted solution]

Thank you very much for the prompt reply; it solved my problem!

So the lack of decimal places rounded up all results to 1?

Is that all that I was missing?