Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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