Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 In Progress between Sep 15 and Sep 16.
Ideally i would like to compare this measure for more than two days and plot the measure over dates that are presneted in Column 1.
Sample Dataset is here:
Date | Activity ID | Activity Status |
15 sep 2021 | A | Not Started |
15 sep 2021 | B | Not Started |
15 sep 2021 | C | Not Started |
15 sep 2021 | D | In Progress |
15 sep 2021 | E | In Progress |
16 sep 2021 | A | Not Started |
16 sep 2021 | B | In Progress |
16 sep 2021 | C | In Progress |
16 sep 2021 | D | In Progress |
16 sep 2021 | E | In Progress |
Status Transition =
SUMX (
DISTINCT ( INFO[Activity ID] ),
0 + ( CALCULATE ( DISTINCTCOUNT ( INFO[Activity Status] ) ) > 1 )
)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi,
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] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
53 | |
35 | |
20 | |
16 | |
15 |
User | Count |
---|---|
94 | |
76 | |
36 | |
22 | |
18 |