"Not a fully qualified column reference"
All day I've been trying to figure out why RELATED, RELATEDTABLE, and LOOKUPVALUE don't work for me, and then I realized none of them are working because I'm using Direct Query, but it turns out I'm NOT actually using Direct Query (but should be and need to fix that.) In the meantime, I'm getting the error message that my column is not a "fully qualified column reference"- why else wouldn't my columns be fully qualified if I'm in Import Mode? Meanwhile, I need a new column in the PROPERTY table that lists all the tenants asscociated with each PROP_CODE. The PROP_CODE's match, and you can see it's 1-to-many (which is an issue- I want Power BI to create extra lines in the PROPERTY table to accomodate all the tenants for each PROP_CODE.) RELATED, RELATEDTABLE, and LOOKUPVALUE don't work for some reason. Thanks in advance! Thank-you for your help!
Look at 6+ Columns, Return Related Value
Hi! I am trying to figure out a formula that looks at 6+ values in a row, references my related table and returns the matching value. The LOOKUPVALUE + RELATED function combined has gotten me results for a particular value, however I need to analyze multiple columns. Any help would be greatly appreciated! Thank you! M
Proper Calculation of Facts/Values from Dimensional Table
Source ( Download Here ) Userstory: Imagine you have big star shema model and important values/facts in dimensional Tables. And you don't want to mess up your fact table with multiple low cardinality columns. Question: How to proper handle these dimTable facts/values? Simplified Example: Question: How to get DESIRED YearVolume (because by default it gives 2200 (Totals) in each cell)?Mulitply columns from 2 fact tables (not directly related, but through 2 dimension tables)
Dear PowerBi Community, i am kinda frustrated here and hope someone can help me with dax. I have a data model that holds two fact tables fct_contract_employee and fct_time_tracking. The tables are related through the dim tables as you can see in the data model. I just cant figure out a dax formula to multiply those two. This doesnt work because there is no direct relation between the two tables: Measure = SUMX(Contracts, Table1[Column1] * RELATED(Table2[Column2])) Filtering based on the dim columns doesnt work either: SUMX (FCT_TIME_TRACKING_CONTRACT_LEGACY, FCT_TIME_TRACKING_CONTRACT_LEGACY[TRACKED_WORKING_DAYS] * CALCULATE( FCT_CONTRACT_EMPLOYEE[DAILY_RATE], FILTER( FCT_CONTRACT_EMPLOYEE, FCT_CONTRACT_EMPLOYEE[EMPLOYEE_ID] = RELATED( FCT_TIME_TRACKING_CONTRACT_LEGACY[employee_id]) && FCT_CONTRACT_EMPLOYEE[contract_id] = RELATED( FCT_TIME_TRACKING_CONTRACT_LEGACY[contract_id] ) ) ) )
Dax Formula returning weird error when multiplying from two tables
There are two tables Invoice detail and Rewards; with many - one relationship. Need to create a dax measure two multiply two columns Quantity from Invoice detail and Reward amount from Rewards Table. Total Rewards = SUMX('invoicedetail', ('invoicedetail'[quantity] * RELATED('Rewards'[Reward_Amount]))) used this dax but it is returning the wrong output. It is multiplying a quantity by itself and multiplying it to rewards resulting in wrong output. Wrong output : It would be great if I could get any help. Thank you in advance
RELATED doesn't work in Many-to-One relationship in Power Pivot
Hi I'm using Power Pivot in Excel with a many-to-one relationship. I want to get data from the one side to the many side. I trie calculated column and measure to do so but all failed. The calculated column returned blank and the measure showed error. DAX for the calculated column and measure are the same as below. =RELATED('BH_Capacity_Standard'[Max SKU Capacity]) I remembered I have used similar measure in Power BI and I think there's no big difference between Power BI and Power Pivot about DAX. Thanks in advance!Concatenation using variables
I need to have a result column in my report be a concatenation of text and conditionally, 1 or 2 addtional text 'values'. "Donor+xxxx" - in every row conditionally, if donor # from table 1 matches a donor # from table 2, I need to concatenate "+yyy" Further, if the State in another table = a certain value, additional concatenate "+zzz' Both the yyy & zzz are optional End results could be any of: Donor+xxxx Donor+xxxx+yyy Donor+xxxx+zzz Donor+xxxx+yyy+zzz yyy and zzz are not present in any table, just text values to concatenate. I've been playing with using variables and concatenations and Related, but no success.
Related in Direct Query Mode
Hello! I am trying to do basic calculation Related in the Direct Query mode: Sales Amount = RELATED('product'[Unit_Price]) * sales_streaming[Units] and i get the following error: Is there any work around to perform the calculation between two tables in the direct query mode? Thanks!
RELATED function for Lookup not working
Hi there, I am having difficulties with the RELATED formula and hoping someone can help? All I am trying to recreate an Excel style Vlookup table. Am I going about this wrong way? I have two Queries, TEST1 & LOOKUP. I am trying to add a new column in TEST1 that will return the value from the ‘Area’ column in the LOOKUP query column, where ‘Type (name)’ (from TEST1) matches ‘Type (name)’ (from LOOKUP). This is the code so far that I am placing inside a Custom Column [#"Type (name)"] = RELATED(LOOKUP[Area]) I have created a one to many relationship for the Type (name) in TEST1 & LOOKUP But this is the error message. Does anyone have any idea where I am going wrong? Any help massively appreciated
