Forum Discussion
Solved
Column total as average
I have a table with two columns of data: Absenteeism and Turnover. In the total of the Absenteeism column, the BI is bringing the average of the months. Already in the total of the Turnover column h...
jonathanmathes , You can switch total to avg or sum depending on need using isinscope
if(isinscope(Table[Year]) && Not(Isinscope(Table[Month])) , sumx(summarize(Table, Table[Year], Table[Month], "_1", [measure]), [_1]), [Measure])
or
if(isinscope(Table[Year]) && Not(Isinscope(Table[Month])) , AverageX(summarize(Table, Table[Year], Table[Month], "_1", [measure]), [_1]), [Measure])
Hi jonathanmathes ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin