Forum Discussion
Solved
Calculating the average factor for months with data
Hello, I have a visual a table with: Month - name of the month Avg Sale Per Year - average sale in Januaries, Februaries etc. from selected timeframe Sold CY - sold in current year in each mont...
Hi Fistachpl
Did you apply sort by column to the Month field? If so, please add the sort reference field to the ALL function as well, you can try below measure.
AvgWsp over the year = COUNTX(ALL('TMiesiące'[Month],'TMiesiące'[Month Number]),[AvgWsp]) // Change the 'TMiesiące'[Month Number] to your acthal name, which should be use to sort by column setting.For the rationale for doing this, pls see my answer in another thread.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Tomorrow I will read about this sorting but I did not have top change the sorting in any way. It worked perfectly.
Thank You!