Forum Discussion

cn4422's avatar
cn4422
Helper 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)
    )
lbendlin's avatar
lbendlin
Super User
1 year ago

You can only hide them if they are empty throughout.

 

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

cn4422's avatar
cn4422
Helper V
1 year ago
lbendlin wrote:

You can only hide them if they are empty throughout.

 

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

 

This is how it should look like and here is the

Sample Data

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Same problem as before.  You would need to provide yet another reference table with the list of measure names as a column. Then you would have to add that column to the rows area of the matrix, and condense all your current measures into one.