Cannot count at the context table

[Damir85]

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

SUMMARIZECOLUMNS dont work with context.

[Anonymous]

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

[pmay]

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

[pmay]

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?

[Damir85]

It doesnt work.