Forum Discussion

IK's avatar
IK
Regular Visitor
2 years ago
Solved

Dax

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 f...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Did you try my solution?

  • _AAndrade's avatar
    _AAndrade
    2 years ago

    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.

     

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi,

Try this:

IF(

ISINSCOPE( name of your manager column),

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

IK's avatar
IK
Regular Visitor
2 years ago

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

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    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.