Dax

[IK]

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.

Spoiler

Manager plan=CALCULATE ( SUM('Manager_Plan'[Plan, %]))

[_AAndrade · Accepted solution]

Did you try my solution?

[Anonymous]

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

[IK]

I want in result empty cell for clients. 

[_AAndrade · Accepted solution]

Did you try my solution?

[_AAndrade]

Hi,

Try this:

IF(

ISINSCOPE( name of your manager column),

CALCULATE( SUM('Manager_Plan'[Plan, %]))
)

[IK]

Hi. Thank you for reply. But it doest work((

[_AAndrade · Accepted 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.

[IK]