How to show result in a columns total by dividing other two columns total value

[jatneerjat]

Hi,

I want to show the value in column C's Total by dividing Col A's and Col B's Total.

How can i achieve this?

Thanks

[themistoklis · Accepted solution]

How about this:

Measure = DIVIDE(COUNT('TABLENAME'[Customers]), COUNT('TABLENAME'[Orders]))

Make sure that there is no nulls in any cells on both columns.

You can turn null cells to zero using IFERROR(,....., 0)

[jatneerjat]

Hi @themistoklis

Thank you for your response but how to show this measure value in Column C's Total?

[themistoklis]

@jatneerjat

Have you checked if there are null values?

If they exist then you will never see the total