Forum Discussion

Lourini90's avatar
Lourini90
Frequent Visitor
4 years ago
Solved

Aggregate Measure correctly by condition on DATEDIFF

I have the following Table:     It represents processes with a certain category. And there is also a Date Table over column TIMESTAMP. I would like to show a Measure based on another Measu...
Aggregation
DATEDIFF
DAX
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Hmm. I think ALLSELECTED ( DATUM ) is destroying the PROCESS filter context. Try ALLSELECTED ( DATUM[Date] ) instead.

     

    I'm not sure that this will work though. There's a decent chance you'll have auto-exists trouble without a date dimension table.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

You need to sum over each process individually or else the maximums in AGE are taken over all of the processes simultaneously rather than one at a time.

 

SumNew = SUMX ( VALUES ( Workflow[PROCESS] ), [New] )

 

Lourini90's avatar
Lourini90
Frequent Visitor
4 years ago

Thanks for replying!
For some reason nothing is shown here:

any idea? 🙂

 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    Hmm. I think ALLSELECTED ( DATUM ) is destroying the PROCESS filter context. Try ALLSELECTED ( DATUM[Date] ) instead.

     

    I'm not sure that this will work though. There's a decent chance you'll have auto-exists trouble without a date dimension table.