Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
93 | |
88 | |
35 | |
35 |
User | Count |
---|---|
154 | |
101 | |
80 | |
63 | |
54 |