'RELATED' function in an IF Statement

I doubt usage need to change to =

Refer https://databear.com/dax-related-table-functions/

Is it a measure or columns ?

Try like

Working Hours = IF('Main'[Location]= RELATED(Indianlocations[Location]),9,IF('Main'[Location] = RELATED(Otherlocations[Location]),8,0))

Hi DevadathanK ,

IN operator in Power BI returns either TRUE/FALSE value. So, I don't think it is used correctly here.

Try modifying your DAX as follows:

Working Hours = IF(

                                 'Main'[Location] == RELATED(Indianlocations[Location]), 9, 

                                  IF('Main'[Location] == RELATED(Otherlocations[Location]), 8, 0)

                               )

In case you want to use IN operator, try following DAX:

Working Hours = IF(

                                 'Main'[Location] IN RELATED(Indianlocations[Location]) = TRUE(), 9, 

                                  IF('Main'[Location] IN RELATED(Otherlocations[Location]) = TRUE(), 8, 0)

                               )

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

DevadathanK 

The problem is you can only use table expression after IN, 

Try replace RELATED() with RELATEDTABLE() or VALUES():

Working Hours = IF('Main'[Location]IN RELATEDTABLE(Indianlocations),9, IF('Main'[Location] IN RELATEDTABLE(Otherlocations),8,0))

Working Hours = IF('Main'[Location]IN VALUES(Indianlocations[Location]),9,IF('Main'[Location] IN VALUES(Otherlocations[Location),8,0)))))

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.