cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jatneerjat Member
Member

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

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?

 

1.PNG

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
themistoklis New Contributor
New Contributor

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

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)
3 REPLIES 3
themistoklis New Contributor
New Contributor

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

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 Member
Member

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

Hi @themistoklis

 

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

 

 

themistoklis New Contributor
New Contributor

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

@jatneerjat

 

Have you checked if there are null values?

 

If they exist then you will never see the total