Forum Discussion
Create a relationship between Fact Table Values and Measure Values
- 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))
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi lbendlin ,
finally, here is the sample Data.
Sample Data
(You don't need to have dropbox to download the file)
see attached
lbendlin Thanks for your effort, looks almost perfect. 🙂
Two questions:
1. How did you manage to arrange the quarters like you did?
When I do it, they are arranged differently...
2. What I still don't know is how to link the measures "CPL GA DE" and "CPL FB DE" to an overall "Country DE"... so that it looks like this...
Thanks again for your help, very much appreciated!
1. Read about "Show values on rows"
2. You would need to use a disconnected reference table if you really want to show the country columns.