Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
Thank you. I´ll try to figure out how to embed this calculate in my other complex Measure.
Best Regards
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |