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 am trying to get all students from my table 1 that do not exist in table 2 using EXCEPT function. I was able to get it work when filters were hardcoded but as soon as i added dynamic filter, results show me blank. Not sure why this is happening. I am attaching the measure that is working and not working respectively (i have cohort and enrollment terms as two different slicers)
Solved! Go to Solution.
problem has been resolved. second filter was applied for both which is why result was blank. thanks for trying
problem has been resolved. second filter was applied for both which is why result was blank. thanks for trying
Are these two the same data type ? 'Dim Enroll Term'[Term Description] & selectedTrackingTerm
Proud to be a Super User!
Paul on Linkedin.
they should be as selectedTrackingTerm = selectedvalue('Dim Enroll Term'[Term Description]). Meanwhile i created another report to see if its behaving same with other filters (added 4 other slicers) and works perfect.
1. If i have to think relationships are wrong here, measure should not work when hardcoded?
2. same measure with Intersect function works fine too, problem i have when using Except here particularly
@sunnysrujan how you tested the selectTrackingItem is returning the value?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
yes i did test and it does return the selected value of the Tracking Term
@sunnysrujan also it is very hard to provide a solution without knowing how these tables are related to each other. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
selectTrackingTerm is single selection and yes it is showing value, also i tested the same measure by providing hardcoded values and it gave me accurate results, which is why this is confusing
@sunnysrujan can you check what selectedTrackignTerm is returning? SELECTEDVALUE function will return blank if you are selecting more than one value
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |