Calculation between two unrelated data sources

[jtownsend21]

Hi all, I have two data sources that I cannot relate, but would like to be able to do something like the following. Is this possible using DAX (or any other functionality)?

Revenue is calculated as a sum while appeals are calculated by a distinct count. Other than filtering to a given date range (month/qtr/year) there are no other filters. 

Thoughts? 

SEE SAMPLE DATA HERE

[Greg_Deckler]

So, are those two calculations measures? If so, you should just be able to divide them. Sample data helps tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[jtownsend21]

They are calculations from two different tables which have no relationship and therefore I don't know of a way to simply divide them. 

Just updated the original post with a link to some sample data. Sorry I didnt include it on the first go around. Cheers

[Greg_Deckler · Accepted solution]

Looking at this I'm not sure that I fully understand what you are trying to accomplish but what I would recommend would be to first create a New Table with the following formula:

Calendar = CALENDARAUTO()

This should create a calendar table that you can then relate to both of your other tables. Then you can create a slicer based upon this new Calendar table.

Then, you would have the following measures:

Revenue = SUM('Revenue'[NetRevenue])

Appeals = DISTINCTCOUNT('Appeals'[Appeal Id])

RevenuePerAppeal = DIVIDE([Revenue],[Appeals],0)

[jtownsend21]

That worked perfectly! I was trying to connect the date on the two tables, but hadn't thought about creating an independent calendar table. Thank you for your help on this!