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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Cfrance28
New Member

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

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 NameTimepointPatient Enrolled (Cumulative)
Site 1

January 2022

5
Site 2January 20229
Site 3January 20223
Site 1February 202213
Site 2February 202222
Site 3February 20227

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.