Forum Discussion
Damir85
5 years agoFrequent Visitor
Cannot count at the context table
Hello i need to count how many rows with 3 conditions.
SUMMARIZECOLUMNS dont work with context.
4 Replies
- pmayResolver I
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?- Damir85Frequent Visitor
It doesnt work.
- pmayResolver I
What columns exist in Project and what relationship do you have configured between Project & Allocation?
- AnonymousNot applicable
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