Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
78 | |
54 | |
39 | |
35 |
User | Count |
---|---|
102 | |
84 | |
48 | |
48 | |
48 |