Forum Discussion
Drill Down Dynamic Measure
Anonymous, ive notice if i just do maxx for client name and remove the project name from the axis, it returns correctly but as soon as i add the project name to the axis, the measure starts acting up and its like it doesnt know how to use aallselected.
my current workaround after countless tries is to just not do drill down but to use tooltips, i created a new page tooltip size for projetc name and now i just hover over my client name and i can see the project level.
this is a niche workaround as if more projects get created, we cant scroll down in tooltips so im limited to seeing only multiple projects.
i hope powerbi team adds a new feature that will help tackle this issue with drill down
Hi Anonymous
The key to the problem may be to ensure that the measure correctly identifies the current level of detail and calculates the MAXX value accordingly.
I tried the following changes to your code:
DynamicMaxMeasure =
VAR IsClientLevel = ISINSCOPE(dimClient[ClientName])
VAR IsProjectLevel = ISINSCOPE(dimProjects[project.name])
RETURN
IF(
IsClientLevel,
MAXX(ALLSELECTED(dimClient[ClientName]), [Total Tickets Created No Bugs]) * 1.5,
IF(
IsProjectLevel,
MAXX(ALLSELECTED(dimProjects[project.name]), [Total Tickets Created No Bugs]) * 1.5,
BLANK()
)
)
This measure uses this function to determine the current level of detail.
It checks whether the context is at the client level or the project level and calculates the maximum value accordingly. If neither context applies, a blank is returned.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello Anonymous , thank you for taking the time to help me out.
I've tried using this measure but still doesnt work and now the reference constnt line just shows blank.
by client level:
by project level