Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |