cancel
Showing results for
Did you mean:
Highlighted
jatneerjat 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? Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
themistoklis New Contributor

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

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

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

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

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

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

themistoklis 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

Announcements Top Kudoed Authors
Users Online
Currently online: 381 members 4,469 guests
Recent signins:
• dqG9kYbAmF7tfNx • jazking123 • tasmiaa • PBInath • SDaugherty • powerbi-user • msksenthil • AdamPJ • SanjeevMurthy • Gikho • hgospodinov • Marcadet • renevandeveen • GotYaRG 