Forum Discussion
Helper IIICalculating the average factor for months with data
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~
Super UserHi @Fistachpl
I'm not sure if I understood your question correctly, you can try this measure.
Amount of factors = SUMX(ALL('TMiesiące'[Month]),[AvgWsp over the year])
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
FistachplThis calculates the sum of those but to get average factor I need to calculate the sum (which I already have) and divide it by the number of factors to get the average factor.
I tried to calculate by:
VAR _amountOfFactors =CALCULATE(COUNTX(ALL('TMiesiące'[Month]);[AvgWsp]);FILTER(ALL('TMiesiące'[Month]);[AvgWsp]>0))
and got:
But in the table I want to have 5.
I know I can just use:VAR _amountOfFactors = MONTH(now())-1 (with safety for January so I do not get 0) but I want to learn 🙂- xifeng_L
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~