Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |