Forum Discussion
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 ...
- 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))
