Forum Discussion
Add DIVIDE to 2 calculations
Hi, Is it possible to add in a 'DIVIDE' into these 2 calcualtions please? CALCULATE( DISTINCTCOUNT(Table[cust_no]), Table[dept_no] = 0 ) CALCULA...
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
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
That's perfect, thank you!