Measure

[Krutigawale33]

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

[Krutigawale33]

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?

[negi007]

@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

[Krutigawale33]

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

[fhill · Accepted solution]

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'?

[Krutigawale33]

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?

[Krutigawale33]

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

[Krutigawale33]

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

[fhill]

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