Forum Discussion
Average with diferent total
Hi, Can you help me? I have issues with this measure and I don´t know the reason. name 1ª VISIT 2ª VISIT Category Total result name1 02/06/2021 16:29 23/06/2021 14:50 3 82,8% na...
"And we need a measure. Average =the average of the visit but the total is the sum of the category average / category"
About as clear as mud. Can you explain clearly what you need?
the average of the "category total result" and the total is the average of the "category total result" divide by category
Sorry. Same clarity as before.
Sorry, I try again
Now, I am using
Total R = IF(HASONEVALUE(Table'[Name], AVERAGE( 'Table'[Total result] ), SUMX( Table, AVERAGE ( 'Table'[Total result] ) / SUM(Table[Category])).
the average of the result: If "The Result" is 4 and there are two visit. the average is 2.
That for each row.
But the total result I need the sum of the average, divide total category