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 a table with a text column, and a calculated column which is derived from a measure. The measure is calculating text values from data in a related table.
End result is one table with two text columns with similar text data.
StandardTextColumn | CalculatedTextColumn |
ValueA | ValueA |
ValueB | ValueD |
ValueC | ValueB |
ValueD | ValueD |
I want to highlight where the values do not match.
When comparing the columns, a false outcome is always produced.
StandardTextColumn = CalculatedTextColumn = False
EXACT(StandardTextColumn,CalculatedTextColumn) = False
StandardTextColumn | CalculatedTextColumn | Expected Result | Actual Result |
ValueA | ValueA | True | False |
ValueB | ValueD | False | False |
ValueC | ValueB | False | False |
ValueD | ValueD | True | False |
I have checked data types and tried using CONVERT/TRIM to enure both are text data.
I have tested with other standard text columns within the same table and it works, so it seems to be from the interaction with the calculated text column.
Any help is appreciated.
@Elscc Can you just share the sample formula which you have used to create a measure and calculated column ?
What is the relationship between text table and related table?
Regards,
Shalini
Hi,
Please see my other reply for the measure and calculated column formula. My DIM_C and Episode tables have a 1-1 active relationship.
Many thanks in advance for any help.
Can you share the DAX that you have for your measure and calculated column?
Proud to be a Super User! | |
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |