Groups data's percentage

VitorXavier — Fri, 13 Dec 2019 17:50:40 GMT

Hello,

I'd like to get a percentage of canceled contracts per segment. I have the total contracts values and the canceled contracts during 2019, but I am not getting the results that I need, for example:

Let's think about the item "SMB Foco", I'd like to get the percentage of R$ 1.514.3483,09 divided per R$ 5.041.472,58, but when I made a measure to divide it the measure returns the division of R$ 1.514.348,09 divided per R$ 23.152.092,52 that is the total of contracts values.

How can I get the division of the group and not of the total?

Re: Groups data's percentage

az38 — Sat, 14 Dec 2019 08:39:50 GMT

Hi VitorXavier

its difficult to advice without example of data model but it seems like you are not use row context. maybe you have an excessive ALL filtration

it should looks like

= divide( calculate(sum('Table'[CHURN LIQUIDO 2019])); calculate(sum('Table'[ARR])) )

do not hesitate to give a kudo to useful posts and mark solutions as solution

topic Re: Groups data's percentage in DAX Commands and Tips

Groups data's percentage

Re: Groups data's percentage