Forum Discussion

cn4422's avatar
cn4422
Icon for Helper V rankHelper 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
    2 years 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
Icon for Super User rankSuper User
2 years ago

 

cn4422's avatar
cn4422
Icon for Helper V rankHelper V
2 years ago
lbendlin wrote:

 

Thanks again for your help - that's great, I can see not how you did it!

 

What if I want to add more countries... The idea is that the measure should only be placed in the row if the country-code is a match, if not, then it should simply be omitted.

 

What would be the best approach here?

My first idea was to maybe try it with a switch-statement?