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

Anonymous
Not applicable

## creating target and difference account owner wise performance - help

 Account Owner Achived FFE Target FFE TARGET% Difference of Target and Achived FFE % Difference Radha 100 700 14% -                  600 -86% Nina 200 700 29% -                  500 -71% Priya 300 500 60% -                  200 -40% South 300 300 100% - 0% Monica 200 400 50% -                  200 -50% Grand Total 1,100 2,600 42% -                             1,500 -58%

Hi, I want to create above table with following target list and booking list. Can somebody please help with dax measures and create PBIX with this data and share PBIX file creating above table in report page please.

 Target List Account Owner Target Radha 700 Nina 700 Priya 500 South 300 Monica 400

 Booking List Shipment creation date Shipment number Customer code FFE Account Owner 15-Sep-2020 5237r8238 123456 1 Radha 30-Sep-2020 76575745 7891011 1 Nina 20-Sep-2020 357238r83 123456 1 Priya 16-Sep-2020 5238059023 7891011 0.5 South 15-Nov-2020 636363 123456 1 Monica 16-Nov-2020 36363434634 7891011 1 Radha 17-Nov-2020 2362362363 123456 1 Nina 18-Nov-2020 6346436 7891011 0.5 Priya 19-Nov-2020 636363632 123456 1 South 20-Nov-2020 63634634 7891011 1 Monica 21-Nov-2020 765685675 123456 1 Radha 22-Nov-2020 856854745 7891011 0.5 Nina 22-Nov-2020 7453462323 7835abrd 0.5 Priya 22-Nov-2020 7548903 fgthdfg56 0.5 South

2 REPLIES 2
Super User

@Anonymous , You need to have common dimesion Account Owner , if not check this , how to create https://www.youtube.com/watch?v=Bkf35Roman8

Then measure try

FFE = sum(Booking[FFE])

Target FFE = sum(Target[Target])

Target% = divide([FFE],[Target FFE])

difference = [Target FFE]- [FFE]

difference % = divide([difference], [Target FFE])

Super User

@Anonymous

Can you explain how you calculated the following two numbers for Radha?

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

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 - August 2024

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

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors