Forum Discussion

fsu5078's avatar
fsu5078
Regular Visitor
3 years ago

Use Total Record to Create Future Estimate

The project I am working on will use figures from Database 1 to create the average % of funds used for the past year.  I used a mix of columns and measures to finally get the % I desired.  The average of the % used is showing in the totals record at the bottom of my report.  

 

I am looking to reference that average and mulitple it against future numbers that would come from database 2.  I am hoping someone with more knowledge in PowerBI can assist me by showing me how to reference that total record.

 

The records in yellow are the two fields (both measures).  At the end of the day, I would have a column that would reference a future amount against the % Wells Collection and another column that would reference a future amount % Wells Disb.

 

For examples- % Wells Collection would be $1,000,000 * 32%

                        % Wells Disb would be $1,000,000  * 34%

 

 

Thank you in advance.

Need Help

2 Replies

    • fsu5078's avatar
      fsu5078
      Regular Visitor
      3 years ago

      Thanks amitchandak and sorry for not making this clear.

       

      I have a filter on this report to show only the prior year.  The % Wells Collection column is a measure field based on a division formula from two other columns in the table so that it would tell me what % of the total funds collected belonged to Wells.  From there, I wanted to find what the average was and use that to help me determine what future estimates could be.  

       

      I couldn't seem to find a way to create the average of this one column (% Wells Collection) other than showing it in the Total Record (which I highlighted in the print screen).  I now want to apply this one figure (32%) against future values.  

       

      For example, if 9/15/23 has an estimate of $1M, I would like to take future amount * % (1M * 32%).  Then 9/18/23 has an estimate of $2M, it would be $2M *32%.

       

      Is there a way to reference the amount shown in the totals section (32%) in a column or measure?  

       

      I apologize if I confused you even further.