Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |