HI Everyone. I'm learning how to use PowerBI desktop and I'm new to the forum. I hope everyone could help me with this.
I imported 2 excel files, each has 5 tables that are almost identical. They are pre and post conversion results in number of outstanding units.
I created measure of % of ownership for both set of data.
I linked these two set of data by employee Unique ID table. Using ID from this employee ID table, then select pre conversion or post conversion, it returned the correct number of outstanding units. However, the percentage returned 100% for all employees.
When I pull employee ID from pre conversion table, it gives me correct % of ownership for each employee, same as for post conversion.
Select Outstanding Units = IF(SELECTEDVALUE('Select Period'[Period])= "Pre Conversion", 'Select Period'[Pre-C Outstandings],'Select Period'[Post-C Outstandings])
Select % = IF(SELECTEDVALUE('Select Period'[Period]) = "Pre Conversion", [% Ownership Pre-C],[% Ownership Post-C])
Your help is much appreciated.