Forum Discussion

cn4422's avatar
cn4422
Helper V
2 years ago
Solved

Create a relationship between Fact Table Values and Measure Values

Hi,   I have attached a screenshot of what I would like to accomplish.   The idea is to create CPL (Cost-per-Lead) for different countries and display them over a certain time period.   I have ...
  • lbendlin's avatar
    lbendlin
    1 year ago
    CPL FB =
    SWITCH(SELECTEDVALUE(Countries[Country]),
    "DE",DIVIDE([Sum Spend DE FB],[Sum Leads DE FB],0),
    "AT",DIVIDE([Sum Spend AT FB],[Sum Leads AT FB],0)
    )
lbendlin's avatar
lbendlin
Super User
1 year ago

In that case you are indeed staring down the barrel of having to use the SWITCH statement 17 times.

cn4422's avatar
cn4422
Helper V
1 year ago
lbendlin wrote:

In that case you are indeed staring down the barrel of having to use the SWITCH statement 17 times.

You are awesome - thank you so much! It's working exactly as I had in mind! 😍

 

(The downside with 17 countries is the performance, it's taking ages to load the visual 😁)