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.
Hi. I have a sales plan for managers, not for clients. When I build a hierarchy in a matrix of tables, where first the manager is then the client, I want the plan to show only for managers, and not for clients. Can anybody please correct my code? My tables are interconnected with each other. they are different tables.
Manager plan=CALCULATE ( SUM('Manager_Plan'[Plan, %]))
Solved! Go to Solution.
Hi,
Please try this formula:
Manager % =
IF(
ISINSCOPE(T_FormulaDax[ManagerID]) && NOT(ISINSCOPE(T_FormulaDax[Client])),
SUM(T_FormulaDax[Plan%]),
""
)
In my example is working as you want. Please let me know if this solve your problem.
Proud to be a Super User!
Hi, @IK
Have you solved the current problem? @_AAndrade in the latest reply, a good solution is provided.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
I want in result empty cell for clients.
Did you try my solution?
Proud to be a Super User!
Hi,
Try this:
IF(
CALCULATE( SUM('Manager_Plan'[Plan, %]))
)
Proud to be a Super User!
Hi. Thank you for reply. But it doest work((
Hi,
Please try this formula:
Manager % =
IF(
ISINSCOPE(T_FormulaDax[ManagerID]) && NOT(ISINSCOPE(T_FormulaDax[Client])),
SUM(T_FormulaDax[Plan%]),
""
)
In my example is working as you want. Please let me know if this solve your problem.
Proud to be a Super User!
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
108 | |
104 | |
83 | |
73 |