Add DIVIDE to 2 calculations

[Anonymous]

Hi, 

Is it possible to add in a 'DIVIDE' into these 2 calcualtions please? 

CALCULATE(
                   DISTINCTCOUNT(Table[cust_no]),
                   Table[dept_no] = 0
)

CALCULATE(
                   DISTINCTCOUNT(Table[dept_no]),
                   Table[mort_no] = Y
)

[goncalogeraldes · Accepted solution]

Hello there @Anonymous! Not sure if this is what you are looking for:

Divide =
VAR _value1 =
    CALCULATE ( DISTINCTCOUNT ( Table[cust_no] ), Table[dept_no] = 0 )
VAR _value2 =
    CALCULATE ( DISTINCTCOUNT ( Table[dept_no] ), Table[mort_no] = Y )
RETURN
    DIVIDE ( _value1, _value2 )

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

[Anonymous]

That's perfect, thank you!