The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi. I've worked with Power BI for about 6 months, but not fiddled to much with DAX. Now I'm faced with an issue.
I have a table with two fields, Name and Value. I want to do a DISTINCTCOUNT of names, but only those where they have a value >0.
Any tips?
Solved! Go to Solution.
OK, so I think I figured it out:
OK, so I think I figured it out:
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |