Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Kr1s
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:

 

ContractProductPlannedActual
1131
1232
131010
22100
2411
311010
33109
35108

 

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

 

ContractPlannedActualActual %
1161381%
21119%
3302790%

 

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
Pragati11
Super User
Super User

Hi @Kr1s ,

 

Consider the following Input data:

Pragati11_0-1602515265338.png

 

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

Pragati11_1-1602515366058.png

 

Pragati11_2-1602515413229.png

 

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

Pragati11_3-1602515499473.png

 Now move this calculated measure to your table visual:

Pragati11_4-1602515535335.png

 

You will get your expected result.

 

Thanks,

Pragati

 

 

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

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

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

2 REPLIES 2
Pragati11
Super User
Super User

Hi @Kr1s ,

 

Consider the following Input data:

Pragati11_0-1602515265338.png

 

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

Pragati11_1-1602515366058.png

 

Pragati11_2-1602515413229.png

 

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

Pragati11_3-1602515499473.png

 Now move this calculated measure to your table visual:

Pragati11_4-1602515535335.png

 

You will get your expected result.

 

Thanks,

Pragati

 

 

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

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

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11 ,

 

Thank you so much!

 

Kristian

Helpful resources

Announcements
Europe Fabric Conference

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.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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