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.
Hello,
I have one fact table with two relationships to a mastercalendar. Given I am looking for open_dates and resolved_dates..
I have the relationship active on the open_dates.
My problem is one tab is all about the resolved_at dates, so my measures have the USERELATIONSHIP to make sure the measure takes into consideration the resolved_dates..
I have one table that gives raw numbers of incidents.. and I have a drill-through to a page giving the specifics of each incident, the problem is for example, if the incident was open_at 2/2/2018 and my MasterCalendar slicer is on 4/2/2018 and I see one incident in my table, when I drill-through to see the details, it does not appear because the "Date" of the incident is based on the open_at (2/2/2018) because its where my active relationship looks at, thus filtering it out.
Anyone faced this issue? Any solution?
Thanks!
Solved! Go to Solution.
I have the same issue also solved it by dragging the measure in the report, yes it shows 1 on each row but now it's also giving memory error "visual has exceeded the available resource" issue because the DAX is becoming very complicated as the measure is repeating on each row. There should be some other way to solve this. Any other inputs are welcome, please. I don't want to end up giving these query more memory to run with, that is not a good solution.
I am having this same issue (using two different dates on two different pages that I woud like to drillthrough with). I am successfully using USERELATIONSHIP to get my measures all working as I want, but I am not able to figure out what you mean by just dragging and dropping a measure with the userelationship to make it work. Are you able to supply some more details of how you pulled this off?
Hey!
In my case the drill-through would just push me to a tab with one table.
The data missing due to the problem I have mentioned, disappeard, once I dragged the measure I was seeing correctly in the other tab (that uses USERELATIONSHIP) inside the table.. as then I forced the table to use that same relationship.
Was that clear? I dont know exactly how your PBI looks like, so I am not sure on how my solution could work for you.
Cheers
Thanks, this worked for me. In my case my measure is a count so I end up having to shrink down that measure column as it just shows "1" over and over, but the table's context uses the inactive relationship as I want.
@Anonymous,
Check if selecting the no impact icon helps.
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |