How can i divide results of visuals?

[flavioa]

Hi everyone, I am new to the community and the BI . I would like to know how to divide the results of a view, since it is complicated to me DAX formulas. In this table I have time ( A) and stops (B ) , but is filed by customers ( C ) . I would like to know how to make ΣA / ΣB regarding C.

 

[Greg_Deckler · Accepted solution]

Create a new measure:

Measure = SUM([A]) / SUM([B])

Put it in the table and it will be context filtered by row.

Edit for @konstantinos, if you are worried about SUM([B]) being 0, use:

Measure = DIVIDE(SUM[A]),SUM[B])

[flavioa]

Thanks Smoupre, Your response has been very helpful 😄