Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report Builder: How to create a Calculated Field using data from 2 different Data Sets

Hi,

 

I'm very familiar with Power BI Desktop but new to Power BI Report Builder.

 

My question is:  Is it possible to create a calculated field in Power BI Report Builder using data from 2 different Data Sets?

 

For example, I'd like to create a calculated field like the following:

PMPM

= ((Sum(Fields!PlanPaid.Value, "Claims_Rolling12")) / (CountDistinct(Fields!EmployeeID.Value, "Eligibility_Rolling12")))

 

It would be using the Sum of [PlanPaid] from my "Claims_Rolling12" Data Set and dividing it by the Distinct Count of [EmployeeID] from my "Eligibility_Rolling12" Data Set.

 

I would need the table to look like this:

 

Both the Claims_Rolling12 Data Set and Eligibility_Rolling12 Data Set have a column called Date that is formatted the same.  I'm just having trouble creating the Calculated Field.

 

Is this type of thing possible in Report Builder?

 

 

2 Replies