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
    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)
    )
cn4422's avatar
cn4422
Icon for Helper V rankHelper V
1 year ago

lbendlin 


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 ğŸ˜„

 

Video 

 

Thanks in advance! ^^

 

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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

  • cn4422's avatar
    cn4422
    Icon for Helper V rankHelper V
    1 year ago

    lbendlin The problem is that I don't know how to provide sample data without giving away sensitive information in this case.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      You create new sample data without sensitive information.

  • cn4422's avatar
    cn4422
    Icon for Helper V rankHelper V
    1 year ago

    Hi lbendlin ,

    finally, here is the sample Data.

    Sample Data 
    (You don't need to have dropbox to download the file)

      • cn4422's avatar
        cn4422
        Icon for Helper V rankHelper V
        1 year ago

        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!