Forum Discussion
Resolver IEnable column total for a non summarized column.
Hi Preeti_Yadav ,
You can create another new measure as below base on the measure with average calculation(Suppose the measure is named car_weight), later check whether it can get your expected result...
Measure = SUMX ( VALUES ( 'rbr'[jobid] ), [car_weight] )If the above one doesn't work, please provide some sample data from rbr table with Text format and your expected result with calculation logic and special example screenshots. It is better if you can share a simplified pbix file with me. You can refer the following thread to upload your file in the community. Thank you.
How to upload PBI in Community
Best Regards
Super UserPreeti_Yadav , You need to have a group by to have sum of avg
Calculate(sumx(rbr,calculate(averagex(rbr,rbr[column])))
Calculate(sumx(values(rbr[Column]) ,calculate(averagex(rbr,rbr[column])))
refer
Average of Sum https://www.youtube.com/watch?v=4xn0A43jBz8&list=PLPaNVDMhUXGZNyKU0PgG2g3P0c6CPjMnj&index=9
Resolver IHi tamerj1 amitchandak .
I already tried those measures ut to no avail.
That gave me an output like below;
i.e. my row value got chnaged.
I want my row values to be seen as Average and total in Sum.
Can you suggest me some other logic?
- tamerj1
Community Champion
In the report visual, what are you slicing by?
- Preeti_Yadav
by jobid.
- tamerj1
Preeti_Yadav
TryTotal = SUMX ( VALUES ( rbr[jobid] ), CALCULATE ( AVERAGEX ( rbr, rbr[column] ) ) )
