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 created a calculated column and want to return country names from the countries table. I am on the buildings table.
My DAX
Column =
IF (
ISBLANK ( RELATED ( Countries[Country] ) ),
RELATED ( Countries[Country] ) = "Other",
RELATED ( Countries[Country] )
)
I get an error saying expressions that yield variant data type cannot be used to define calculated columns.
The countries table has 2 columns Code and Country. Code is the 2 letter abbrevition while Country is the full name.
Ex.
AU AUSTRALIA
What I'm trying to say is return the country name but if the value is blank then return the text "Other"
Thanks.
Solved! Go to Solution.
I figured this out. I needed to remove the RELATED before other.
Working DAX
Column =
IF (
ISBLANK ( RELATED ( Countries[Country] ) ),
"Other",
RELATED ( Countries[Country] )
)
I figured this out. I needed to remove the RELATED before other.
Working DAX
Column =
IF (
ISBLANK ( RELATED ( Countries[Country] ) ),
"Other",
RELATED ( Countries[Country] )
)
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |