Forum Discussion
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...
Jihwan_Kim
Super User
Super UserHi,
I am not sure if I understood your question correctly, but please check the below picture and the link down below, that is the sample pbix file.
Ideal result measure : =
VAR newtable =
ADDCOLUMNS (
VALUES ( Data[Activity ID] ),
"@statuschange",
CALCULATE (
IF (
COUNTROWS ( SUMMARIZE ( Data, Data[Activity ID], Data[Activity Status] ) ) > 1,
1
)
)
)
RETURN
SUMX ( newtable, [@statuschange] )