Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
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])
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
GrandTotal = CALCULATE ( [TotalAmount], ALLSELECTED ( TableName[Nome] ) )
% GT Percentual 2020 = DIVIDE ( [Total Amount], [GrandTotal] )
Replace TotalAmount with the SUM ( ColumnName )
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])
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
11 | |
10 | |
8 |