Forum Discussion
How to use IF(Selectedvalue)
| Stakeholder ID | Name | Outstanding Units |
| 1 | John Smith | 100 |
| 2 | Mary Smith | 200 |
| 3 | Jones Brown | 300 |
| 4 | James Swenson | 400 |
| Stakeholder ID | Name | Outstanding Units |
| 1 | John Smith | 150 |
| 2 | Mary Smith | 200 |
| 3 | Jones Brown | 300 |
So the first table with 4 stakeholders is the pre-conversion table, the second one with 3 stakeholders is the post conversion. I joined these 2 tables 1:1.
I created measure to get % ownership for each stakeholder in each table: % Ownership Pre COnversion and % Ownership Post Conversion.
I created a table as SELECTED PERIOD with only 1 colum and 2 rows for selection of Pre Conversion, Post Conversion, in order to use the IF(SELECTEDVALUE)
I added slicer to the page by filter names from the first table (4 stakeholders).
When I select Pre COnversion or Post conversion for John Smith for example: the % Ownership show 100% for him in both cases.
However, when I pull %ownership pre conversion in the field with the pre conversion name table, I get the correct % ownership. For example in John Smith case, it is 10% pre conversion. Similar to post conversion, % ownership for John Smith is 23% which is correct.
I hope this help explain my question. And thank you so much for your time trying to help me on this.