get total as division of Other 2 column's Total values in the table view in power bi

[Vaishnav]

Hi,
I have a Table visual in power  BI with below mentioned columns.

I want "MTT  Total" value as ... Division of  "Friction Total" and "Count Total"...…(Friction Total /Count Total )....

724034 / 7139=101.41

but I am  getting it as 101.46

could you please guide to get it as  724034 / 7139=101.41....in the same table as "MTT Total"..

please refer below mentioned table

Type	Count	Friction	MTT
P1 - Critical	10	30.299999999999997	3.03
P2 - High	90	12243.13953488372	136.03488372093022
P3 - Medium	662	59000.61927330174	89.12480252764612
P4 - Low	1405	136807.9326574946	97.37219406227372
xyz	4972	515952	103.77152051488335
Total	7139	724034	101.46

[v-hashadapu]

Hi @Vaishnav , Thank you for reaching out to the Microsoft Community Forum.

Please see the attached .PBIX file for your reference.

Note: 724034 / 7139=101.419, so it will be rounded to 101.42.

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[Vaishnav]

Hi @v-hashadapu 
I need  that value as part of the table...at "Total" field under "MTT"  Column ( Highlighted in Red)

[rajendraongole1]

Hi @Vaishnav  - You need to create a new measure for MTT Total that does the division using total values, not the summed-up MTT values.

MTT Total =

DIVIDE(

    SUM('Test'[Friction]),

    SUM('Test'[Count])

)

Hope this helps and works

[Vaishnav · Accepted solution]

Hi, Thanks for you support.

Finally I could fix the issue.

Posting the calculation...as it might help someone in future...

--correct the Total with sumx(summarize...) and use it in the division 

CorrectTotal =

        VAR a = SUMMARIZE (

            Table,

      Table[Type],

            "Revised", CALCULATE( Table[Friction], VALUES( Table[Type]) )

        )

        RETURN SUMX( a, [Revised] )

_division =

var x=Table[CorrectTotal]

var y=DISTINCTCOUNT(Table[number])

return DIVIDE(x,y)

[Vaishnav]

Hi @rajendraongole1 
I need  that value as part of the table...at  "Total" field under "MTT"  Column ( Highlighted in Red)