Need help

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...

Tips and Tricks

Anonymous

4 years ago

Hi Anonymous ,

Create two measures Please refer the following formulas.

answer =

var ss =

CALCULATE(MAX('Table'[Activity Status]),FILTER(ALL('Table'),'Table'[Date]=SELECTEDVALUE('Table'[Date])-1&&'Table'[Activity ID]=SELECTEDVALUE('Table'[Activity ID])))

var aa =

IF(ISBLANK(ss),SELECTEDVALUE('Table'[Activity Status]),ss)

var change = IF(SELECTEDVALUE('Table'[Activity Status])=aa,0,1)

return change

times = SUMX(ALLEXCEPT('Table','Table'[Date]),[answer])

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

Best Regards

Community Support Team _ Polly

Need help.pbix38 KB

answer = var ss = CALCULATE(MAX('Table'[Activity Status]),FILTER(ALL('Table'),'Table'[Date]=SELECTEDVALUE('Table'[Date])-1&&'Table'[Activity ID]=SELECTEDVALUE('Table'[Activity ID]))) var aa = IF(ISBLANK(ss),SELECTEDVALUE('Table'[Activity Status]),ss) var change = IF(SELECTEDVALUE('Table'[Activity Status])=aa,0,1) return change

Forum Discussion

Need help