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))
One more question regarding the Switch-Statement: Is there a way to "hide" empty rows?
In this example, I have two SWITCH-Statements
And I want it to be only shown in the correct Country-row.
I tried to add "BLANK()" to the statement, which didn't work.
I tried to put a filter over the visual with ">0" and I checked if "empty rows" was deactivated...
But I couldn't manage to hide the rows with no values in the matrix...
Any idea if this is possible?
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.
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.
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