Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello i need to count how many rows with 3 conditions.
Hi @Damir85,
Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
What columns exist in Project and what relationship do you have configured between Project & Allocation?
If your relationships are valid, why not simply use this?
Calculate
(countrows(Project),Filter(Allocation, Allocation[ContractorName = Blank()
))
Do you have relationships configured between the tables?
It doesnt work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |