Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |