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

## Planned Vs Actual by Contract

Hi,

I have a set of data that has a list of contracts with the planned amounts and actual amounts by product, like this:

 Contract Product Planned Actual 1 1 3 1 1 2 3 2 1 3 10 10 2 2 10 0 2 4 1 1 3 1 10 10 3 3 10 9 3 5 10 8

And I need to summarise it at contract level with the actual %, like this:

 Contract Planned Actual Actual % 1 16 13 81% 2 11 1 9% 3 30 27 90%

No matter what I do it doesn't do what I need, it always seems to just give me a % of the total or return null values.

Any help is greatly appreciated.

Thanks,

Kristian

1 ACCEPTED SOLUTION
Super User

Hi @Kr1s ,

Consider the following Input data:

Now create another table visual as follows by setting Summarisation on Planned and Actual columns as shown below:

Then create a measure for calculating the proportin percentage and set it's format to Percentage as shown below:

Now move this calculated measure to your table visual:

You will get your expected result.

Thanks,

Pragati

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

2 REPLIES 2
Super User

Hi @Kr1s ,

Consider the following Input data:

Now create another table visual as follows by setting Summarisation on Planned and Actual columns as shown below:

Then create a measure for calculating the proportin percentage and set it's format to Percentage as shown below:

Now move this calculated measure to your table visual:

You will get your expected result.

Thanks,

Pragati

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

Frequent Visitor

Hi @Pragati11 ,

Thank you so much!

Kristian

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.