Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

need some help with this DAX

I have two CM "DSKfromlastcyle = VAR _PreviousCycle = SELECTEDVALUE(CC[CycleNum])-1 VAR _DateShiftKetAfter = CALCULATE(MAX(DimCrewSchedule[DateShiftKey]),CC[CycleNum]= _PreviousCycle) RETURN _...
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, Anonymous 

    Thank you very much for your reply. You should put this metric and DateShiftKey column in table visual. See if you get the expected results. The metric needs to rely on an external context such as the DateShiftKey column to work.

     

    Best Regards,

    hackcrr

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

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
2 years ago

Hi, Anonymous 

Perhaps you could try the following dax expression:

SortingNum1 = 
VAR DSKValue = [DSKfromlastcyle]  
RETURN  
    CALCULATE(  
        MAX(DimCrewSchedule[SortingNum]),  
        FILTER(ALLSELECTED(DimCrewSchedule),
        DimCrewSchedule[DateShiftKey] = DSKValue
        )
    )

The results are as follows:

 

 

Best Regards,

hackcrr

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    hackcrr 

    Thanks for helping, I tried the DAX you provided, but it still gives me blank

    • hackcrr's avatar
      hackcrr
      Icon for Memorable Member rankMemorable Member
      2 years ago

      Hi, Anonymous 

      Thank you very much for your reply. You should put this metric and DateShiftKey column in table visual. See if you get the expected results. The metric needs to rely on an external context such as the DateShiftKey column to work.

       

      Best Regards,

      hackcrr

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