Create an Average calculation grouping by two different fields
I need to create the calculation for the avg score grouping by subtheme per each client(case ID). I created a expected output based on some inputs values: As you can see, first all i need to sum the score per subtheme, then divide each client score for the subtheme which its belongs. I have tried several formulas, such as: Nothing works as expected: sometimes the values returned are the same as the score field for each client/caseid, or either it just calculate the sum of the score/count(total clients), what is not true, sice the nominator will variate depending of the score oh that or other specific client per suntheme each belongs. If someone know how to solve it. i would appreciate a lot. 🙂
DAX
Hello, I have Table with 3 columns Project Number, Project Cost and extraction Date. Each end of month, i do extraction to know the cost of each project. How to write dax powerbi to calculate the changes of the only running projects over months, and exclude the First record of project number i.e. first Date "in extaction date" of Project number - But to start count thos new record from the second month as long as they existed ?
How to Sum Row Count and show total sum value in every row
Hi community, Hoping you can assist, i am trying to Sum my count and show the total in a new column for every row. See below: Total Occupany is a measure counting the records based on my slicer selection. I I am trying to sum the count values into a new column and show the value in every row. Thanks in Advance
dynamic percentage
Hello everyone. I am currently working with the following dynamic table. The idea of this is that in the %Total column of Count Uid, 100% appears for the product in general, but when subdividing it by the price range, it appears to me the percentage that each range is distributed to form 100%. I currently have this DAX measure, but I have not been able to discriminate each percentage in order to achieve my objective. %Total Count Uid for Ranks = VAR Den = CALCULATE([Count Uid], ALLSELECTED(Compliances)) RETURN DIVIDE([Count Uid],Den) If anyone can help me with this I would be grateful. Thanks in advance for any assistance.Porcentajes en tabla dinamica
Hola a todos. Actualmente me encuentro trabajando con la siguiente tabla dinamica. La idea de esta es que en la columana de %Total de Contar Uid me aparezca el 100% para el producto en general pero al subdividirlo por el rango de precios me parezca el porcentaje que se reparte cada rango para formar el 100% Acutualmente tengo esta medida de DAX, pero no he conseguido que discrimine cada porcentaje para poder lograr mi objetivo. %Total de Contar Uid para Rangos = VAR Den = CALCULATE([Contar Uid], ALLSELECTED(Cumplimientos)) RETURN DIVIDE([Contar Uid],Den) Si alguien me puede ayudar con esto quedo agradecido. Gracias de antemano por cualquier ayuda.
What-if parameters
At the retail company i work, the sales men are giving the customers discounts. At the end of the year, the sum of sales after discount =100M and the total dicounts amount=45M. i want to make a what if parameter to the discounts in which i make it dynamic to show that : if we decreased the discount amount by 10% the sales would have increased by so and so .. how can I achieve that ?
