cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Get the total on each row

Good afternoon,

I need help to make a measure of percentage (Column "Percentual 2020"):

I need to make de 415 stay in each row in the column "Total de sub motivos 2020" to get the correct percentage. How can I create the DAX function to get it?

2 ACCEPTED SOLUTIONS
Super User

you do this by modifying the filter context, for example:

Total =Calculate(sum(table[Qtd motivos 2020]),ALLSELECTED(table))

or

Total = SUMX(ALLSELECTED(table),table[Qtd motivos 2020])

Employee

To get the overall total, you can use a measure like this

Overall Total = CALCULATE(SUM(Table[Total de sub motivos 2020]), ALL(Table[Nome]))

Also, you don't need to do it in a separate measure, you can put them all together in one measure and just have your % of Total measure if you want.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

4 REPLIES 4
Employee

To get the overall total, you can use a measure like this

Overall Total = CALCULATE(SUM(Table[Total de sub motivos 2020]), ALL(Table[Nome]))

Also, you don't need to do it in a separate measure, you can put them all together in one measure and just have your % of Total measure if you want.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

Frequent Visitor

Olá Vitor,

Pelo que percebi você gostaria de ter o % de cada justificativa, ou seja, quanto 92 representa % de 415...se for isto, sugiro que na medida que incluir para o "Total de Sub Motivos 2020" marque para "Mostrar Valor Como" - Porcentagem do total Geral.

Espero que te ajude!

fdorta

Community Champion
``GrandTotal = CALCULATE ( [TotalAmount], ALLSELECTED ( TableName[Nome] ) )``
``% GT Percentual 2020 = DIVIDE ( [Total Amount], [GrandTotal] )``

Replace TotalAmount with the SUM ( ColumnName )

Super User

you do this by modifying the filter context, for example:

Total =Calculate(sum(table[Qtd motivos 2020]),ALLSELECTED(table))

or

Total = SUMX(ALLSELECTED(table),table[Qtd motivos 2020])

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors