Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
8 years ago
Solved

Dax Countx

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

Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    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's avatar
      Fcoatis
      Post Patron
      8 years ago

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

       

      Best Regards