Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone, i'm currently trying to create a measure using count ids after status change. I created tthis table with the desired results im looking for.
ID | Month | Status |
1 | Jan-19 | OK |
2 | Jan-19 | OK |
3 | Jan-19 | OK |
4 | Jan-19 | OK |
1 | Feb19 | Pending |
2 | Feb19 | Pending |
3 | Feb19 | OK |
4 | Feb19 | OK |
1 | Mar-19 | OK |
2 | Mar-19 | Pending |
3 | Mar-19 | Pending |
4 | Mar-19 | OK |
1 | Apr-19 | Pending |
2 | Apr-19 | Pending |
3 | Apr-19 | Pending |
4 | Apr-19 | Pending |
What i need is a graph showing me the amount of ids that changed from "ok" to "pending" in this example.
Desired Results in this Example | |
Feb-19 | 2 |
Mar-19 | 1 |
Apr-19 | 2 |
Drive : https://docs.google.com/spreadsheets/d/1avTU1EUpn3fs8wXYJ0X1Yc3Y4crs_ux-9fC90c9xwGE/edit#gid=0
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
bump
Hi,
You may download my PBI file from here.
Hope this helps.
@Ashish_Mathur wrote:Hi,
You may download my PBI file from here.
Hope this helps.
Hello @Ashish_Mathur , it worked with the example i used however, will that same measure work with a data base with 110,000+ different ids?
Try that yourself.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |