Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Im trying to Count distinct Vendors based on if they have a spend value in a different table.
With the DistinctCount I get 9 vendors but as in the right table I only want to show 7 since those are the one with spend data.
I have the Vendor name in one table(1) and the spend data in another tabel(2), I have linked them through vendor number.
The reason for 9 insted of 7 is that 2 of the vendors do not have any actual spend during 22-21
Solved! Go to Solution.
Hi as I mentioned I dont have the vendor in tabel 1 & the spend in Tabel2. This solution dos not take that into consideration if I understan it correctly
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |