calculation with several filters

[Anonymous]

hello!

I am struggling to make a measure with the data I have:

OPERATOR	HOUR	UNIT ID (unique values)
1	8	123
1	8	111
2	8	145
2	9	172
2	9	159
3	10	658
3	10	221

I would need to do this calculation : divide the sum of unit ID which is a unique value per row by the sum of hours by user. The idea is to divide the sum of total units by the amount of total hours.

Thanks!

[Anonymous]

this was the final solution:

divide(Distinctcount(Table[UNIT ID]), Countx(summarize(Table, Table[OPERATOR],Table[HOUR]),[HOUR]))

Thanks amitchandak!

[Anonymous]

hello amitchandak!

In the example that I corrected so it is more clear, the desired output is: sum units (7) / sum different hours by user (4):

user 1: 1 hour

user 2: 2 hours

user 3: 1 hour

I am going to try your measure. Thanks!

[amitchandak · Accepted solution]

@Anonymous , Try like

divide(sum(Table[UNIT ID]), Countx(summarize(Table, Table[OPERATOR],Table[HOUR]),[HOUR]))

or

divide(Count(Table[UNIT ID]), Countx(summarize(Table, Table[OPERATOR],Table[HOUR]),[HOUR]))

[amitchandak]

@Anonymous , Expected output is not clear try a measure

divide(sum(Table[UNIT ID]), sumx(summarize(Table, Table[OPERATOR],Table[HOUR]),[HOUR]))