Workarounds for dividing calculated columns?

[DJSwezey]

I have a dashboard that contains 3 tables:

1) Buys

2) Goals budget

3) Markets

The 3 are related via MarketName where 'Markets' is the fact table.

Below are two calculated columns that give a projection on number of leads and number of showed people according to the corresponding market. My matrix contains "Market Name" as the main row header and then drills down into DayPart as well. What I want to do is show the ratio of # of people who showed versus # of leads (showed/leads). But I cannot do this with these calculated columns. Am not sure the workaround on this.

P.S. SumOFLeads and SumShowed are also calculated columns in the 'Buys' table.

projLeads = 
CALCULATE (
    SUM ( Buys[SumOFLeads] ),
    FILTER (
        Buys,
        Buys[DayPart] = 'Goals budget'[DayPart]
            && 'Goals budget'[weekof] = Buys[weekof]
            && 'Goals budget'[MarketName] = Buys[MarketName]
            && 'Goals budget'[Length] = Buys[Length]
    )
)

projShowed = 
CALCULATE (
    SUM ( Buys[SumShowed] ),
    FILTER (
        Buys,
        Buys[DayPart] = 'Goals budget'[DayPart]
            && 'Goals budget'[weekof] = Buys[weekof]
            && 'Goals budget'[MarketName] = Buys[MarketName]
            && 'Goals budget'[Length] = Buys[Length]
    )
)

[lbendlin]

The 3 are related via MarketName where 'Markets' is the fact table.

That doesn't sound right.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523