Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

fhill
5 years ago
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'?

8 Replies

fhill
Resident Rockstar
5 years ago
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'?
- Anonymous
  Not applicable
  5 years ago
  Hello fhill Thans....That's working as expected..
  here I have one more doubt, how to remove digits after decimal point.
  - fhill
    Resident Rockstar
    5 years ago
    Here you go, select the new %GT Column under Field Formatting
- Anonymous
  Not applicable
  5 years ago
  I got the result for that too in field formatting we can change "value decimal places".
- Anonymous
  Not applicable
  5 years ago
  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?
negi007
Community Champion
5 years ago
Anonymous 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
- Anonymous
  Not applicable
  5 years ago
  This is not working I have to filter data in column data with another column value
Anonymous
Not applicable
5 years ago
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?

Related content