topic Re: BI - How to calculate the percentage of a specific value where the total is the same column in DAX Commands and Tips

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

apolo — Thu, 03 Apr 2025 13:47:02 GMT

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

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

bhanu_gautam — Thu, 03 Apr 2025 14:05:17 GMT

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)

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

KiranKusmude — Thu, 03 Apr 2025 14:20:57 GMT

A% =

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

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

return

divide(_Acnt,cnt)

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

v-dineshya — Fri, 04 Apr 2025 09:57:50 GMT

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

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

v-dineshya — Tue, 08 Apr 2025 12:34:37 GMT

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

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

v-dineshya — Mon, 14 Apr 2025 17:59:32 GMT

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

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

v-dineshya — Tue, 22 Apr 2025 04:20:44 GMT

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