Solved: Cannot convert value 'Occupation' of type Text to ...

Cadu · ‎11-25-2022

Hi, I have writen this new column and it returns the error: Cannot convert value 'Occupation' of type Text to type True/False.

Does someone know how to solve it?

New column =

(IF(OR

(ISBLANK(FACT_V[ROLE]),

FACT_V[ROLE]=""),RELATED(FACT_E[Roles]),

IF(RELATED(DIM_B[Occupation]),(FACT_V[ROLE]

))))

JorgePinho · ‎11-25-2022

I believe it is because of this part: "IF(RELATED(DIM_B[Occupation])," since the first argument of an if statement should be a logical test.

View solution in original post

KNP · ‎11-25-2022

Formatting the code would certainly make it easier to help. I think @JorgePinho is right about the bit he's highlighted, what were you expecting that to do/test for?

Consider using a SWITCH statement instead of nested IFs. It can make the logic much simpler.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr

Proud to be a Super User!

JorgePinho · ‎11-25-2022

I believe it is because of this part: "IF(RELATED(DIM_B[Occupation])," since the first argument of an if statement should be a logical test.

Cannot convert value 'Occupation' of type Text to type True/False.

Helpful resources

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly