Creating a Measure to Calculate Expected Amount by Date

[MTOnet]

I'm having difficulty coming up with a measure to display information the way I want.  I don't have a lot of experience and am still teaching myself, while trying to create something that may be useful within my organization.

My data is setup in a similar fashion to this

Table 1

Table 2

I have a measure caluclating the total number of scripts for the selected project.  For this example, lets use 1000 as our total.  I'm trying to get the measure so that it has results like below, so that I can add it to a visualization to show exp

Measure Result

I have tried different solutions, but I can only come up with a solution for a specific date.  I can't get it for the series of dates for the selected project.  I do have these values as a calculated column, but i wasn't able to add it to my visual since they  are seperate tables and I wasn't able to associate them together, so that is why I am trying a measure.

[v-eachen-msft]

Hi @MTOnet ,

You just need to create a measure.

Expected Scripts =
SUM ( table2[Expected Percent] ) / 100 * 1000

Then create a table visual and slicer visual to display result.

But I don't understand the role of table1. Can you provide more detailed instructions?

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.