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.

     

IK's avatar
IK
Regular Visitor
2 years ago

I want in result empty cell for clients. 

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Did you try my solution?