Subtotal and total not showing
Hi all, I get values in the rows, but no values in the subtotal or total. I need the subtotals and total to be the average of the values. I have the following DAX: Volume compliance (on archetype level) = VAR NoOfMetrics = 2 VAR VolumeCon = AVERAGEX('SiteSnaphot Volume', ([CBM - Inbound (%)] + [CBM - outbound (%)]) / NoOfMetrics) VAR VolumeDecon = AVERAGEX('SiteSnaphot Volume', ([Cartons - Inbound (%)] + [Cartons - outbound (%)]) / NoOfMetrics) VAR VolumeFul = AVERAGEX('SiteSnaphot Volume', ([Units - Inbound (%)] + [Units - outbound (%)]) / NoOfMetrics) RETURN SWITCH(SELECTEDVALUE('SiteSnaphot Volume'[ArcheType]), "Consolidation", VolumeCon, "Deconsolidation", VolumeDecon, "Fulfilment", VolumeFul) Furthermore, if you have a solution on how I can make the VolumeCon etc. more dynamic that dividing with 2. This is a snip of the subtotal (upper white cell with no value) and row value (blue cell with 100%). Furthermore, the [CBM - Inbound (%)] etc. are measures that I have created. Hope you can help me. Viktor
Average in subtotal and grand total of a RANKX
Hi all, I have a database with the financial results of several companies by quarters from 2018 to 2021, I have created the following measure in order to give a ranking to each company according to the indicator that is evaluated (for this example "Ventas" and " Activos"): Measure = VAR Ratio = IF( ISBLANK( MAX(Ratios[Valor])), BLANK(), RANKX( FILTER(ALL(Ratios), Ratios[Fecha] = MAX(Ratios[Fecha]) && Ratios[Indicador] = MAX(Ratios[Indicador])), CALCULATE( SUMX(Ratios, Ratios[Valor] + Ratios[NIT] / 1000000000000) ),,DESC,Dense ) ) VAR ColumnaX = ADDCOLUMNS(Ratios,"Rank",Ratio) RETURN IF( HASONEVALUE(Ratios[Fecha]), Ratio, AVERAGEX(ColumnaX,[Rank]) ) Everything was going well until I tried to calculate in the subtotals and grand total the average of the rankings or qualifications that each company has had. For example, in the table below I selected a specific company to check the sub totals and grand totals: As you can see, the formula is not calculating the averages of the rankings for each year and quarter. Do you know if there is a solution for this, in what part of the formula I am falling? Thanks
YTD Monthly Headcount AVG
Hello, I currently am trying to get YTD Monthly Headcount AVG, as well as, Monthly HC Avg for the previous 2 months. However, my monthly HC is calculated by this formula: "Employee Count = VAR selectedDate = MAX('Date'[Date]) RETURN SUMX('employees', VAR employeeStartDate = [startDate] VAR employeeEndDate = [termDate] RETURN IF(employeeStartDate<= selectedDate && OR(employeeEndDate>=selectedDate, employeeEndDate=BLANK() ),1,0) )" Sorry I don't have any data to share. Please let me know your suggestions ASAP. Thank you!
Dax Measure to get the average of a column at total level
Hi everybody, Im trying to do a dax measure that has to calculate the total average of the values of the column cells, this measure has to work with any attributes and/or level in the pivot table (excel). The thing is I have correct values only at store level, but no for the other attributes in my model. To better describe my problem, I attached a sample power BI file. thanks a lot for your help! Power BI Sample FilePutting up the measure to the visual with correct average grand total
Hi Guys, I am quite new to PBI, I have this problem if you can help that will be great. in the ss you can see the filters and liquid visual that use for my data. in this page I am trying to get the, lets say , total score of a country in a given month. when I choose just a month it shows me the correct result. However, when I choose april may june , it adds up the score which I dont want it like that. I want to see it as average of the total. there are single KPI(s) and months and scores in the raw data. when I choose the average in the value section it shows me the average of the KPI(s) which is again not someting that I want to see. I ve tried the GROUP BY and SUMMARIZE dax(s) to come up to a solution but ı ve ended up in the same spot where I started. I believe it is something easy but I dont know what it is . thanks for the solutions in advance
Average Grand Total doesn't calculate correctly
Currently , i am looking for Average in Grand total but apparently ,which ever way i write Dax my Total only aggregates instead of Average. In attached example the average that i am expecting is 0.875 for my test measure in grand total apparently , it only adds up and doesn'tr resolve the context Here is my Dax for TEST measure Test = IF( ISFILTERED('Funding Source'[Allocation]), (Sum('Capacity Fact'[AllocationAmountin Minutes])/Sum('Date'[Is Weekday]))/480, Sumx('Provider Capacity Fact' , 'Capacity Fact'[AllocationAmountin Minutes]/Sum('Date'[Is Weekday])/480 ))
