Forum Discussion
Issues with calculating AVERAGEX with and without using ALLEXCEPT
Hello All, I want to calculate Average percent change over a grouped category but I keep getting a blank column. I have tried with ALLEXCEPT, and I have tried with using SUMMARIZE with the same...
Bmejia
Super User
Super UserYour calculation with Allexempt is working, I am not sure why you are getting blanks.
That is bizzare. I wonder if its a datatype issue? What were your column formats when you pasted the above into pbix?