Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
My dataset is working based on location filter and every page has sync filters. Comment per location work fine however whenever I try the region filter for "North America" it does not retrieve region comment's and bring cumulative comments for 3 locations instead of "North America" region's comment. Is there a way to better design or bring region comments when region is picked from the slicer. Btw, could not find a way to upload my file so I put the screenshots instead. Please let me know if there is a way to upload file instead.
Thanks for the input however I want to display "Good IT Performance" when North America is picked for region instead of displaying 3 records per site. I don't know how but feel like lookupvalue should have been the other way.
Hi @beginner
You can lookup the comments from other table using LOOKUPVALUE DAX as below:
Hope this helps!
If I answered your question then mark my post as "Accept it as the solution" and a kudo would be appreciated.March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |