Enable column total for a non summarized column.

[Preeti_Yadav]

Hi all.

I have a column which shows values in a non summarized format.
The column is displaying values as average.
I want to enable the total for this particular column.
for that I created a measure as;
Total=Calculate(sumx(rbr,averagex(rbr,rbr[column]))

Can someone suggest me a DAX to enable total.


Thanks,
Preeti

@amitchandak @tamerj1 @Jihwan_Kim @jossiv @Greg_Deckler @johnt75 

[tamerj1]

Hi @Preeti_Yadav 
Try 

Total =
SUMX ( rbr, CALCULATE ( AVERAGEX ( rbr, rbr[column] ) ) )

[johnt75]

I think you can just replace the column in your table visual with the measure you have created.

[amitchandak]

@Preeti_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

[Preeti_Yadav]

Hi @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]

In the report visual, what are you slicing by?

[Preeti_Yadav]

by jobid.

[v-yiruan-msft · Accepted solution]

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

[tamerj1]

@Preeti_Yadav 
Try 

Total =
SUMX ( VALUES ( rbr[jobid] ), CALCULATE ( AVERAGEX ( rbr, rbr[column] ) ) )