Need Help creating measure for maximum sum of a column for a projection

Cfrance28 — Thu, 25 Aug 2022 16:02:40 GMT

Hello I am trying to create a line graph visual that includes a projection of program enrollment over time (enrollment numbers on y axis, time on x axis). The project has 10 different sites enrolling patients to participate. The maximum number of individuals that can be enrolled by site is 130. I have the graph and I have the projection but I want to add a new measure that will cap each site at 130 so I can get an accurate estimate on timeline to study completion (enrollment= 1300). The dataset I'm using was designed for another purpose so it is in a less than ideal format but I think it can accomplish what I need. Below is a sample of the data table

Table Name: Test Tab

Site Name	Timepoint	Patient Enrolled (Cumulative)
Site 1	January 2022	5
Site 2	January 2022	9
Site 3	January 2022	3
Site 1	February 2022	13
Site 2	February 2022	22
Site 3	February 2022	7

Re: Need Help creating measure for maximum sum of a column for a projection

amitchandak — Fri, 26 Aug 2022 03:56:23 GMT

Cfrance28 , Based on what I got,

You can have a measure

max enrollment= 130

Use that as line in visual or as constant line using analytics pane -> constant line -> fx

topic Re: Need Help creating measure for maximum sum of a column for a projection in DAX Commands and Tips

Need Help creating measure for maximum sum of a column for a projection

Re: Need Help creating measure for maximum sum of a column for a projection