User Profile
ivancespedesl
Helper I
Joined 7 years ago
User Widgets
Contributions
Average of a measure with several count and sum
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:Re: Client status over time
Hi, To clarify the matter let's explain the desired result: IF Customer_Status on the last period was S and now it is S, 'Active' IF Customer_Status on the last period was N and now it is N, 'Inactive' IF Customer_Status on the last period was S and now it is N, 'Deserted' IF Customer_Status on the last period was N and now it is S, 'Reactivated' This tracking must be done through the Customer ID that remains constant with the client over time.Re: Changing column graph displayed value and getting measures out of it
Hi, Using this code I was able to create a variable that gives me this output: This allows me to get the totals and graphs depending on the selection as I want to be presented: However, Im having problem making measures as Average, MoM%, etc. I think the problem is that it does not understand the time variables, therefore, does not calculate properly. What I want to do is to create measures as Average, MoM% that work for every variable selected so I want to do this calculations specifically to the variable Measure. Any other info you need, Im at your service.
