Average of a measure with several count and sum

[ivancespedesl]

I have two identical measures, one with COUNT and another with SUM. The measure is the following:

Mix. =

COUNT('Data clientes lunes por 12 meses'[Cant_CA])+

count('Data clientes lunes por 12 meses'[Cant_CC])+

count('Data clientes lunes por 12 meses'[Cant_CD])+

count('Data clientes lunes por 12 meses'[Cant_MC])+

count('Data clientes lunes por 12 meses'[Cant_NE])+

count('Data clientes lunes por 12 meses'[Cant_PR_Com])+

count('Data clientes lunes por 12 meses'[Cant_PR_Hip])+

count('Data clientes lunes por 12 meses'[Cant_PR_Hip])+

count('Data clientes lunes por 12 meses'[Cant_PR_LC])+

count('Data clientes lunes por 12 meses'[Cant_PR_Per])+

count('Data clientes lunes por 12 meses'[Cant_PR_Tie])+

count('Data clientes lunes por 12 meses'[Cant_PR_Vh])+

count('Data clientes lunes por 12 meses'[Cant_TC])

I made a graph with this data and I want to know the average at each point. How can I do this? Also, i tried creating a column but it aggregated everything. Here is the pic:

[amitchandak]

I think we need more info but.

if you have count and Sum then you can get it by divide

Avg = divide(_count,_sum)

If possible please share a sample pbix file after removing sensitive information.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[v-eachen-msft]

Hi @ivancespedesl ,

Could you please share your sample data and excepted result to me if you don't have any confidential information. Please upload your files to One Drive and share the link here.

[az38]

Hi @ivancespedesl 

you havent attach the pic

anyway, for me it looks like your statement has no sense. each count in your formula should be the same

could you please, share a sample of desired output?

do not hesitate to give a kudo to useful posts and mark solutions as solution