Forum Discussion

Damir85's avatar
Damir85
Frequent Visitor
5 years ago

Cannot count at the context table

Hello i need to count how many rows with 3 conditions.

SUMMARIZECOLUMNS dont work with context.

4 Replies

  • pmay's avatar
    pmay
    Resolver 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?

  • pmay's avatar
    pmay
    Resolver I

    What columns exist in Project and what relationship do you have configured between Project & Allocation?