Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
2 years ago

need help in a logic/Dax

Hi All,   need one help correction of logic or dax pls.. below is the scenario's..   This is my report page. Here, I've selected Feb in calendare slicer and one employee name in wins slicer. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PowerBIBeginer 

Greg_Deckler  ,thank for your attention to this issue and I want to offer some information so that can help user solve the problem.

You can try the following measure.

test =
CALCULATE (
    MAX ( ZActive[StepUpTarget%] ),
    ALLEXCEPT ( ZActive, ZActive[Employee Name], ZActive[Month] )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • PowerBIBeginer's avatar
    PowerBIBeginer
    Icon for Helper V rankHelper V
    2 years ago

    Thank You Yolo, for your time and responce. Slicer which I'm using on report page are month from "Calendar" table and wins name means "Employee Master" table. i think accordingly this two slilcer you try to use AllExcept statement, is it? If so, how can that be written then, pls guide

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi PowerBIBeginer 

      What is your relationship among the tables,can you provide the relationship among the tables so that I can provide some more information for you.

       

      Best Regards!

      Yolo Zhu