Return rate percentage for each company

[Anonymous]

Hi Team,

I have created an overall return rate for the organization , but as I have to show return rate for each company in the Organziation

The data is 

Comapnies        Returns    Sales

A                           5            35

B                           4            40

C                           6            50

Return data is in a different table and sales in a different table

I tried using divide function but return table is not getting populated for numerator or denominator but for sum function its coming up, hence needed help.

[danextian · Accepted solution]

Hi @Anonymous ,

Try this:

returns % =
CALCULATE (
    DIVIDE ( [returns measure], [sales measure] ),
    ALLEXCEPT ( table, table[companies] )
)

This assumes that both returns and sales measure are connected to the companies field.