Percente

[Anonymous]

HI everybody,

Have I troble to do percent 

What i need

Count i "cidades" and divide foir all "cidades"

What i tried

WHen i put in the graph 

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

Assume you have already get the [cidades] column correctly, then you could create a measure like below:

measure = 
var a = calculate(countrow('atendimentos'),filter(all('atendimentos'),[cidades] = selectedvalue('atendimentos'[cidades])))
var b = calculate(countrow('atendimentos'),ALL('atendimentos'))
return

divide(a,b)

If I misunderstood your meaning, please show some sample data in text format and the expected result you want.

Best Regards,

Jay

[amitchandak]

@Anonymous , You can not use slicer value in a column, You need to create a measure

refer

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

Percent of Total- https://www.youtube.com/watch?v=uO3ojDPOpcg&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj&index=7