Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |