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
Community ChampionIn the report visual, what are you slicing by?
Resolver Iby jobid.
- tamerj1
Preeti_Yadav
TryTotal = SUMX ( VALUES ( rbr[jobid] ), CALCULATE ( AVERAGEX ( rbr, rbr[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