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
)
CALCULATE(
DISTINCTCOUNT(Table[dept_no]),
Table[mort_no] = Y
)
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
2 Replies
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