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))
Hi Anonymous ,
so, finally I'm back with building this report!
Thanks for your suggestions and the file. I checked everything and I think I didn't explain accurtely enough what my challenge is. In your sample report you have the "profit" with respective countries which are part of the "financials" table. I understand how you get relations then.
In my case, however, there are countries, but actually I think it's not relevant. I could also make a new table with a countries column. What I would like to achieve is to then get the measures into this table.
I'm not sure about providing sample data, that's why I'm tryining to explain it as simple as possible in this way. 🙂
What I would like to achieve is to then get the measures into this table.You cannot/should not create calculated columns from measures. They don't have the same context.
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
You cannot/should not create calculated columns from measures. They don't have the same context.
I suppose I'm not familiar enough with PBI yet to grasp this concept...
Also, since I'm not sure how to provide data without giving away sensitive information in this case, I'm trying to illustrate my challenge with the following short video in PBI, in which I can hopefully explain what I'm trying to achieve 😄
Thanks in advance! ^^
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