Forum Discussion
Post PartisanMultiple USERELATIONSHIPS functions within an AND and within a CALCULATE
D_PBI - You need to take the USERELATIONSHIP filters out of the FILTER statement, and add them as additional filters.
Also, I would not recomment using FILTER( 'Table', 'column' ) as you have, this is a classic anti pattern and will result in a slower calculation, you should filter a column rather than a table. Here is a good article for this: https://www.sqlbi.com/articles/filter-columns-not-tables-in-dax/
One final thing, I would recommend simplfying your final condition to use NOT IN {"Value1", "Value2" } etc.
I hope this helps, if you need more please provide the DAX code outside of a screenshot and some sample data.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
Hi D_PBI,
I wanted to check if you had the opportunity to follow up on our previous conversation. If yes can you please provide the sample data so that we can provide you with the accurate and correct solution.
Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
Community SupportHi D_PBI,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Thank you.
Community SupportHi D_PBI,
I wanted to check if you had the opportunity to follow up on our previous conversation. If yes can you please provide the sample data so that we can provide you with the accurate and correct solution.
Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
- v-sgandrathi
Hi D_PBI,
We strive to make sure every issue gets addressed completely. If the previous answer helped, that’s great, please mark it as Accepted and consider giving it a Kudos.
Still facing issues? Just reply here and we’ll be right with you.
Thanks for being a valued part of the community,
- v-sgandrathi
Hi D_PBI,
Hope everything’s working fine now! If you’ve found a fix, feel free to share it and mark the answer that helped you as a solution. It really helps others in the community.
If we don’t hear from you soon, we’ll close this thread for now. But if you ever need help again, just start a new thread, we’re always here to support you.
Thank you.