Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables in my Power BI Report, Fact Table with directquery mode and dimension table with import mode. Fact table is joined to the dimension table through many to one relationship. I am trying to bring a column from the dimension table to the fact table but using the DAX Related function but it is not working. I am getting the following error
Error which i am getting
Relationship is shown below
I cannot use lookup to resolve this issue as i am using directquery in the fact table and i have to create a calculated column only
I am desperately looking for an answer..Can anyone please help in resolving this issue ?
Solved! Go to Solution.
Hi @jaideepnema ,
For mixed mode, you can create calculated column only on tables with import mode.
Best Regards,
Jay
Please somebody help. How can you do mixed mode? I have a MS SQL Server (database) as a source. If I start first query in a specific mode (direct query or import doesen't matter) on the second query the other option mode is disabled. I use Version: 2.121.1642.0 64-bit (september 2023).
Hi Team,
I have a similar situtation where my Fact table is in Direct query and my Dimension table is import mode. Relationship between Fact to dimension table is Many to One.
I need to create a calculated column using some if condition where in I need to use my dimension table column. Unable to use Related DAX Function in the calculated column. its showing the similar Error message.
Any ways to resolve this issue or any other way to achieve to call the dimension column.
Thanks in Advance.
Hi @jaideepnema ,
For mixed mode, you can create calculated column only on tables with import mode.
Best Regards,
Jay
Hi @jaideepnema ,
Can you try modifying your relationship to bi-directional and check?
Also are their any NULL or BLANK values in Fkey column in both of your tables?
Thanks,
Pragati
@Pragati11 thanks for your reply
I tried changing the relationship to both direction it is still not working and giving the same error. Also there are no blanks or NULL values
Hi @jaideepnema ,
Is this a measure that you are creating?
I think yes it's a measure. So, measure needs a summarisation like SUM, AVERAGE, etc.
Try modifying your DAX for the measure as follows:
RelatedCheck = RELATED(SUM(DimPriceValue[Price]))
Thanks,
Pragati
@Pragati11 this is a calculated column i am trying to create and due to some calculation limitation i cannot create a measure
Hi @jaideepnema ,
You mentioned earlier you are using DirectQuery connection which is limiting you from creating columns.
Thanks,
Pragati
Hi @Pragati11 ,
I am trying to create a calculate column and we can create calculated column in mixed mode as per my understanding
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |