Forum Discussion

VitorXavier's avatar
VitorXavier
Regular Visitor
6 years ago

Groups data's percentage

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 ...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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