Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can someone help with DAX Script?

Hello everyone, I am looking for some help in writting a DAX that will give me the following result:   Ideal result = calculate number of activity IDs that have changed status from Not Started to I...
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
Status Transition = 
SUMX (
    DISTINCT ( INFO[Activity ID] ),
    0 + ( CALCULATE ( DISTINCTCOUNT ( INFO[Activity Status] ) ) > 1 )
)