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 added a table called 'LeaveReasons' into the model manually by doing "enter data". I created a relationship with the 'Request' table. I linked the table with the common fields. But when I test in dax to create a new table I am getting msg: the column LeaveReason[category] either doesn't exist or doesn't have a relationship to any table available in the current context.
This is the dax I have:
Solved! Go to Solution.
Hi @wpf_ ,
I believe this is a bug, whereby RELATED() does not work between tables that are mixed Direct Query/Import.
You can check issue progress and vote here: https://community.powerbi.com/t5/Issues/DAX-function-quot-RELATED-quot-does-not-work-between-DirectQ...
Pete
Proud to be a Datanaut!
Hi @wpf_ ,
I believe this is a bug, whereby RELATED() does not work between tables that are mixed Direct Query/Import.
You can check issue progress and vote here: https://community.powerbi.com/t5/Issues/DAX-function-quot-RELATED-quot-does-not-work-between-DirectQ...
Pete
Proud to be a Datanaut!
@wpf_ Question is bit confusing.
Have you created a manual table or created table with DAX? can you share the Model view to see what tables you are dealing with and where is the issue!?
Proud to be a Super User!
@VijayP ,
I cant really share the table because it is a directquery.
I created a table manually by going into "Enter Data". Then i set the relationship in the model view. Then to test it in dax, I tried that code in dax studio and in power bi desktop. In power bi desktop i went to "New Table" and used that code.
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |