Dax Countx

[Fcoatis]

Hello, 

Given the following Table:

I need a measure ( to be used as a Denominator) that counts the number of Alloc per FullJOB.

Result Expected:

AR0347/17-BH has 2 DOs and 3 HDs

AR0347/17-PU has 3 Dos and 4 HDs

click here  for the file

Thanks in advance

[TomMartens · Accepted solution]

Hey,

not sure if this DAX-Measure

Measure = 
CALCULATE(
    COUNTROWS(
        'Table1'
    )
    ,ALL('Table1'[Atividade])
)

is what you're looking for, but on a first glance it looks promising

Regards

Tom

[Fcoatis]

Thank you. I´ll try to figure out how to embed this calculate in my other complex Measure.

Best Regards