Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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.
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |