question

TrangTran-3424 avatar image
0 Votes"
TrangTran-3424 asked TrangTran-3424 commented

DAX - If(Selectedvalue) return value does not return correct value from measure

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.

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered TrangTran-3424 commented

This question is related to Power BI, not Power Query. Please post it over in the Power BI Community forum.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you Ehren. I am still navigating through all channels and try to figure out where is the right place to ask questions. I still can't find where to post a question in the Power BI community site.

0 Votes 0 ·