I'm having a tough time determining the DISTINCTCOUNT of [SO_ID] by Quarter and Year.
When I show the data by indivdual Date it works fine, but when I use Qtr & Year the total is less because a SO_ID may be shipped from multiple times throughout the Quarter. I've tried REMOVEFILTERS on the Qtr & Year date column and had no luck.
Here is the current DAX formula.
I abandoned this project.
User | Count |
---|---|
185 | |
78 | |
76 | |
75 | |
46 |
User | Count |
---|---|
168 | |
92 | |
87 | |
80 | |
74 |