DAX Measure - SUM a measure and divide by rows with values

[BTLYBSCT]

Hi Guys,

First time poster and a new to PowerBI.

I have created a measure which looks up a table and based off the KPI provides a set score.

CC_KPI_SCORE = LOOKUPVALUE('CCO CC_KPI_SCORES_VIEW'[Score],'CCO CC_KPI_SCORES_VIEW'[KPI],AllDurationToSecMeasures[CC_KPI])

Now I would like to SUM up the total of the scores based off the filter of the agent and then divide it by rows with only VALUES in it however when I try CALCULATE(SUM) function I can't pick up the column which I assume due to being a measure.

I have tried everything to my knowledge and can say I'm truly stumped.

Is anyone able to help me out here.

I started with just summing up the total based off filters and I can't even get result.

Thanks in advance!

[v-frfei-msft · Accepted solution]

Hi @BTLYBSCT,

I made one sample for your reference, If it doesn't meet your requirement, kindly share your sample data and excepted result to me.

Measure = CALCULATE(SUM(AllDurationToSecMeasures[CC_KPI_SCORE]),ALLSELECTED(AllDurationToSecMeasures))/CALCULATE(COUNTROWS(AllDurationToSecMeasures))

Also find the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @BTLYBSCT,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank