Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |