topic Re: Get the total on each row in DAX Commands and Tips

Get the total on each row

VitorXavier — Fri, 03 Jul 2020 19:01:19 GMT

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?

Re: Get the total on each row

lbendlin — Fri, 03 Jul 2020 21:37:30 GMT

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

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

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

Re: Get the total on each row

AntrikshSharma — Sat, 04 Jul 2020 09:35:28 GMT

GrandTotal = CALCULATE ( [TotalAmount], ALLSELECTED ( TableName[Nome] ) )

% GT Percentual 2020 = DIVIDE ( [Total Amount], [GrandTotal] )

Replace TotalAmount with the SUM ( ColumnName )

Re: Get the total on each row

fdorta — Sun, 05 Jul 2020 18:55:22 GMT

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

Re: Get the total on each row

mahoneypat — Sun, 05 Jul 2020 23:16:05 GMT

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