Reply
Member
Posts: 121
Registered: ‎05-29-2018
Accepted Solution

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


Accepted Solutions
Senior Member
Posts: 385
Registered: ‎04-14-2018

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)

View solution in original post


All Replies
Senior Member
Posts: 385
Registered: ‎04-14-2018

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)
Highlighted
Member
Posts: 121
Registered: ‎05-29-2018

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?

 

 

Senior Member
Posts: 385
Registered: ‎04-14-2018

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