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.
When adding a calculated column to the output values on a visual (grid), the relationship seems to be broken and a "full outer join" is applied between the two implicated tables.
Basic tables involved:
Records
Tag
Actions
There are 1 to many relationships from Records to Tag and Call tables.
If I output data from Records and Tag, I get the correct result.
If I also output the calculated field, I will get every combination of distinct tag for every record, not just the ones actually in the tag table for that record.
If I remove the calculated field, all back to normal.
Am I using the calculated field incorrectly?
Thanks,
William
Solved! Go to Solution.
Obviously something wrong with that Calculated column.
I've opted instead for doing a query method. Duplicated the actions table, filtered on the ones I want to count, did a group by, then a merge back into Records table.
Not so elagant, but returns the correct results and does not drive me insane!
Would love to get that Calculated column working properly though.
Thanks,
William
Thanks for the quick reply. Cross Filter to Both did not change anything. Below is what the relationships look like (Tag is actually called Assigned Appeals)
Below is output from the Records table, filtered on one specific name. The column in blue is the calculated column.
This is the Assinged appeal, filtered on the same record ID. 2 lines...
When I add the calculated column from Records table, all of a sudden I get this!
Thanks,
William
The inclusion of all the other values is generated by the +0 at the end of your formula.
@Vvelarde The +0 was there to avoid NULLS (or Blanks).
When I remove the +0, records that return NULL from the calculated field are excluded from the output!
Results without calcuated field
results with calculated field (simply added the field)
No filters...
Obviously something wrong with that Calculated column.
I've opted instead for doing a query method. Duplicated the actions table, filtered on the ones I want to count, did a group by, then a merge back into Records table.
Not so elagant, but returns the correct results and does not drive me insane!
Would love to get that Calculated column working properly though.
Thanks,
William
Hi @williamdasilva,
I am very gald to hear that your issue got solved. Please mark your solution as answer, others will find workaround easily.
Thanks,
Angelia
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |