Forum Discussion
Column using two tables
Can you post some sample data? My hunch is you might need to use a measure rather than a column.
| Email Send ID | Email Open flag | Contact ID |
| a2324000500nKcud | 1 | 0000025152dfgr |
| a2324000000nKcz | 0 | a2324000000nKd2 |
| a23524000000nKcj | 1 | a2324000000nKbjg |
| a2324000000nKd9 | 0 | a2324000000nKbH |
| a2324000000nKcF | 1 | a2324000000nKbMg |
| a2324000000nKbgd | 0 | a2324000000nKorg |
| a2324000000nKd2 | 0 | 0000025152dfgr |
| a2324000000nKbjg | 0 | a2324000000nKd3 |
| a2324000000nKbH | 0 | a2324000000nKbjg |
| a2324000000nKbMg | 0 | a2324000000nKbH |
| a2324000000nKorg | 0 |
Email Send Id and Open flag are in the Email results Table
And Contact in another Table
This is the column i have :
Column : Brand Engagement = if('Email Results'[EPR]<0.2,"Not Interested <20%",
If('Email Results'[EPR]=0.2 ||'Email Results'[EPR]>0.2 && 'Email Results'[EPR]<0.5,"Somewhat (between 20% and 50%)",
If(
('Email Results'[EPR]=0.5 ||'Email Results'[EPR]>0.5) && 'Email Results'[EPR]<0.7,"Interested (between 50% and 70%)",
If(
'Email Results'[EPR]>=0.7,"Engaged >70%"))))
And the EPR as a measure
EPR = CALCULATE('Email Results'[SUMEMAILOPEN]/'Email Results'[COUNTSENDID])
I thought about the measure but then i can not use the "brand egagement " as a Slicer or a filter Page...
Thank you for your help in advance :)
Ilh What you have provided does not help in understanding the data enough.
However, you can also use the paremeter option to slice your data for different ranges,