BI - How to calculate the percentage of a specific value where the total is the same column

[apolo]

Good morning, everyone,

I have a column in my report called STATUS, which counts 3 values: "OUT OF DEADLINE", "NO DEADLINE" and "ON DEADLINE".

I'm trying to create a card that indicates the percentage of "ON DEADLINE" in relation to the total. But I can't do it. Does anyone have any idea? It needs to be done using the card view.

I managed to get it to calculate, but by counting. Not by percentage.

Medida = CALCULATE(COUNTA('Relatório SLA'[SITUACAO]),'Relatório SLA'[SITUACAO] IN { "NO PRAZO" })

Thank you in advance for your time, translated by Google translator, sorry for any mistakes.

Here is a brief example:

TRANSLATION

SITUAÇÃO = SITUATION

NO PRAZO = ON DEADLINE

SEM PRAZO = NO DEADLINE

FORA DO PRAZO = OUT OF DEADLINE

[bhanu_gautam · Accepted solution]

@apolo Create a measure to count the total number of statuses.
Create a measure to count the number of "ON DEADLINE" statuses.
Create a measure to calculate the percentage of "ON DEADLINE" statuses.

TotalStatus = COUNTA('Relatório SLA'[SITUACAO])

OnDeadlineCount = CALCULATE(COUNTA('Relatório SLA'[SITUACAO]), 'Relatório SLA'[SITUACAO] = "NO PRAZO")

OnDeadlinePercentage = DIVIDE([OnDeadlineCount], [TotalStatus], 0)

[v-dineshya · Accepted solution]

Hi @apolo ,

Thanks for reaching out to the Microsoft fabric community forum.

DAX code for percentage of "ON DEADLINE" in relation to the total.

Percentage On Deadline =
VAR TotalCount = CALCULATE(COUNTROWS('Relatório SLA'))
VAR OnDeadlineCount = CALCULATE(COUNTROWS('Relatório SLA'), 'Relatório SLA'[SITUACAO] = "NO PRAZO")
RETURN
IF(
TotalCount = 0,
0,
DIVIDE(OnDeadlineCount, TotalCount, 0)
)

After creating the measure, go to the "Modeling" tab in Power BI. Select the measure and choose the "Percentage" format.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[v-dineshya]

Hi @apolo ,

Thank you for reaching out to the Microsoft Community Forum.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @apolo ,

Thank you for reaching out to the Microsoft Community Forum.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @apolo ,

Thank you for reaching out to the Microsoft Community Forum.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[KiranKusmude]

A% =

var cnt=CALCULATE(COUNT('Table'[Column1]),all('Table'[Column1]))

var _Acnt= CALCULATE(COUNT('Table'[Column1]),'Table'[Column1]="A")

return

divide(_Acnt,cnt)

[bhanu_gautam · Accepted solution]

@apolo Create a measure to count the total number of statuses.
Create a measure to count the number of "ON DEADLINE" statuses.
Create a measure to calculate the percentage of "ON DEADLINE" statuses.

TotalStatus = COUNTA('Relatório SLA'[SITUACAO])

OnDeadlineCount = CALCULATE(COUNTA('Relatório SLA'[SITUACAO]), 'Relatório SLA'[SITUACAO] = "NO PRAZO")

OnDeadlinePercentage = DIVIDE([OnDeadlineCount], [TotalStatus], 0)