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 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
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.
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.
I see. Thank you for helping me out 🙂
I tried out both of your suggestions and i got it to work by using VALUES(), but i faced another error whilst using RELATEDTABLE().
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
Hello @Pragati11
Thank you for helping me out 🙂 I tried out both of your suggestions and replacing 'IN' with '==' works perfectly. However, whilst trying out the 2nd method (using True() ) i faced an error.
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
It's a Column and i tired out your suggestion of replacing the 'IN' with '='. It works perfectly now.
Thank you so much!
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |