re: Joining multiple visual report table to calculate the sum

[Anonymous]

Hello Community,

 I have multiple tables giving information like business unit code, payer type, region. The objective is to calculate the estimate revenue coming from each unit by different payer. So from table we are calculating average per day revenue from each payer "Insurance" at specific Business unit "SN000". We have taken total SUM of the revenue and divided by total day categorizing average pay based on Business unit code and payer type. 

Average revenue calculation

From another sheet. we have service. we are pulling data like service date and number of patient served on that day. Which is also

categorize by Business Unit and Payer type.

census report

I had to create seprate table because when I'm trying to put all this information in average rate estimation it will create total patient number instead of giving result like one above telling number of patient on specific date, BU, and payer. We are trying to multiply Number of patient * Average pay  to calculate total for each to calculate rough cash inflow from different unit.

How can I multiply two seprate design by using table visualition to calculate each day revenue based on different categories.

Final objective is to get something like this

final result to be like this

Is their away I can do setup this table like the above one ? id there anyway we can automize the above report to gather this census number everyday for particuliar day and calculate the total of that days and for all days days combine

[v-lionel-msft]

Hi @Anonymous ,

Can't you create a relationship between your tables?
Or as long as two tables are referenced in your measure, a relationship is created between them.

Please send us a copy of the sample data if your problem persists.

Best regards,
Lionel Chen

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