Make a measure don't summarize

[Daniel1993]

Hi, hope one of you can help me!

I want to make a measure that shows the progression in %. 

For example:

Progress visited places (this is a Excel-list with all visited places in each row, summarized to a tabel).

Formula: CALCULATE(COUNT('Data'[Names))

Abigail	16
Bernard	17
Chris	9
Dot	45
Eve	21
Finn	12
Gerard	11

Goals (this is a fixed tabel):

Abigail	50
Bernard	60
Chris	60
Dot	60
Eve	40
Finn	20
Gerard	30
Total	320

When I want to divide the progress with the goals, PowerBI will divide the progress with all the goals (320).

But this is not what I want. For example, I want to see this: Abigail --> 16 divide to 50 = 32% instead of 16 divide to 320.

Abigail	16	32%
Bernard	17	28,3%
Chris	9	15%
Dot	45	75%
Eve	21	52,5%
Finn	12	60%
Gerard	11	36,6%

Is there an easy way to do this?

If you need more information, let me know!

[Anonymous · Accepted solution]

I

Try this

Calcul_goal = divide(selectedvalue(Visits[Visits]),calculate(max('Goal'[Goals]),allexcept(Visits,Visits[Name])))

[Daniel1993]

Thanks, it works for me! 🙂