Forum Discussion
Solved
Weighted Average
Looking for a way Count the number of times a certain dwell time shows up and divide it by the total count of rows shown if filtered. Example: 54 shows up 2 times and there is 24 total rows that are...
DerekC try this measure:
Count Measure = COUNTROWS ( Table ) Total Count Measure = CALCULATE ( [Count Rows], ALLSELECTED () ) Dwell x Wgt% Measure = SUMX ( Table, VAR __dwellTime = Table[Dwell Time] VAR __dwellCount = CALCULATE ( [Count Measure], ALLSELECTED (), VALUES ( Table[Dwell Time] ) ) VAR __weightedPercent = DIVIDE ( __dwellCount, [Total Count Measure] ) RETURN __weightPercent * __dwellTime )✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
parry2k
Super User
Super UserDerekC try this measure:
Count Measure = COUNTROWS ( Table )
Total Count Measure = CALCULATE ( [Count Rows], ALLSELECTED () )
Dwell x Wgt% Measure =
SUMX (
Table,
VAR __dwellTime = Table[Dwell Time]
VAR __dwellCount = CALCULATE ( [Count Measure], ALLSELECTED (), VALUES ( Table[Dwell Time] ) )
VAR __weightedPercent = DIVIDE ( __dwellCount, [Total Count Measure] )
RETURN
__weightPercent * __dwellTime
)
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.