Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate ratio

Hi,   I need to calculate the ratio of some fields. I have the following data, this is the structure of the data.  ID Numbers Date Hour 1 2 05-13-2020 10:00 1 1 05-13-2020 11:00 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Greg_Deckler Thank you for your reply.

I know I can use a percent of grand total, but I want a measure that's calculation the average of all the ratio's of all ID's. And I can't do that with the "percent of grand total" function. Hope you understand my question, sorry for my garbage English.

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

try a measure

Measure = 
DIVIDE(
CALCULATE(SUM(Table[Numbers]), ALLEXCEPT(Table, Table[ID]) ),
CALCULATE(SUM(Table[Numbers]), ALL(Table) )
)