cancel
Showing results for
Did you mean:
Highlighted
Post Patron

## Creating a Relative Frequency table

I have the following dataset in a table named 'Major Funding':

 Word government donors igf government government donors igf government donors no budget yet government donors igf self-funded government donors no budget yet government donors government government government donors government donors private sector government donors self-funded government government donors self-funded self-funded donors self-funded donors self-funded government government government donors government donors self-funded government donors self-funded government donors government donors government self-funded government self-funded donors self-funded government donors self-funded donors self-funded

I then create a measure called RowCountMajorFunding = COUNTROWS('Major Funding')

I then plot a chart of 'Word' as x-axis and 'RowCountMajorFunding' as 'Values' to get the following visual:

How can the above chart be converted into a 'Relative Frequency' chart so that it shows % instead of absolute numbers?

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

## Re: Creating a Relative Frequency table

You can try a measure like

RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),allselected('Major Funding')))
or
RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),all('Major Funding')))

Proud to be a Super User!

2 REPLIES 2
Highlighted
Super User IV

## Re: Creating a Relative Frequency table

You can try a measure like

RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),allselected('Major Funding')))
or
RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),all('Major Funding')))

Proud to be a Super User!

Highlighted
Post Patron

## Re: Creating a Relative Frequency table

Many thanks, works like a charm

Regards,

Chris

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors