cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Make a measure don't summarize

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I

Try this

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

2 REPLIES 2
Anonymous
Not applicable

I

Try this

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

Frequent Visitor

Thanks, it works for me! 🙂

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors