cancel
Showing results for
Did you mean:
Responsive Resident

## Measure

Hello All,

I have column as data and measure Units Sold. I need to create Another measure mix based on units sold/Total

That means for first recor value is 34/108.

This is might be easy but I am not able to recall at this moment. I am facing issue to get that total in division part

 Data Units Sold mix ABC 34 ABD 57 XYZ 2 DGF 15 FFD Total 108
1 ACCEPTED SOLUTION
Resident Rockstar

Does it need to be a meausre?  Can you just add 'Units Sold' again (as a second column), then format the field as 'Percentage of Grand Total'?

Please give Kudos or Mark as a Solution!

Proud to give back to the community!
Thank You!

8 REPLIES 8
Responsive Resident

Hello, I have to find differencce of two fields. If go with this approach its okay to find percentage of fields.

but how to find the diffrence of two such fields?

Do we need to go with measures only?

Super User

@Krutigawale33 create a measure like below

mix = SUM(mix_tab[Units Sold])/CALCULATE(SUM(mix_tab[Units Sold]),ALL(mix_tab[Data]))

let me know if it works for you. thanks

Proud to be a Super User!

Responsive Resident

This is not working I have to filter data in column data with another column value

Resident Rockstar

Does it need to be a meausre?  Can you just add 'Units Sold' again (as a second column), then format the field as 'Percentage of Grand Total'?

Please give Kudos or Mark as a Solution!

Proud to give back to the community!
Thank You!

Responsive Resident

Hello, I have to find differencce of two fields. If I go with this approach its okay to find percentage of fields.

but how to find the diffrence of two such fields?

Responsive Resident

I got the result for that too in field formatting we can change "value decimal places".

Responsive Resident

Hello @fhill Thans....That's working as expected..
here I have one more doubt, how to remove digits after decimal point.

Resident Rockstar

Here you go, select the new %GT Column under Field Formatting

Please give Kudos or Mark as a Solution!

Proud to give back to the community!
Thank You!

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors