cancel
Showing results for
Did you mean:
Helper II

## DIVISION OF VALUES IN THE SAME COLUMN OF A TABLE

Hello All,

We are not able to calculate the below requirement. Please guide us.

We want the requirement as :

a) 5 divided by 7 and the result should be 71%

b) 5 divivded by 20 and the result should be 25%

c) 16 divivded by 31 and the result should be 52%

d) 55 divided by 63 and the result should be 87%

Regards,

Vivek Chavan.

1 ACCEPTED SOLUTION
Microsoft

Hi @VivekC

You may try to use HASONEVALUE Function to create measures to get the percent as requested. For example:

```Percent1 =
IF (
HASONEVALUE ( total[Index] ),
MAX ( total[a] ),
DIVIDE (
SUMX ( FILTER ( total, total[Index] = 1 ), total[a] ),
SUMX ( FILTER ( total, total[Index] = 2 ), total[a] )
)
)```

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft

Hi @VivekC

You may try to use HASONEVALUE Function to create measures to get the percent as requested. For example:

```Percent1 =
IF (
HASONEVALUE ( total[Index] ),
MAX ( total[a] ),
DIVIDE (
SUMX ( FILTER ( total, total[Index] = 1 ), total[a] ),
SUMX ( FILTER ( total, total[Index] = 2 ), total[a] )
)
)```

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

#### The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

#### Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Top Solution Authors
Top Kudoed Authors