Measure can't be used in visual

[Anonymous]

Hello,

I have below table and ratio is calculated by On/Total

Machine	On	Off	Total	Ratio
one	56,919,990.00	19,918,078.00	76,838,068.00	74.08%
two	101,407,451.00	21,289,453.00	122,696,904.00	82.65%
three	1,582,723.00	633,407.00	2,216,130.00	71.42%
four	129,632,460.00	20,119,081.00	149,751,541.00	86.57%
five	196,965,125.00	25,407,489.00	222,372,614.00	88.57%

But when I want use 'Ratio' on treemap or piechart or anything else I can't use it as value of the chart.

Formula of ratio is = FORMAT(DIVIDE(SUM('Data'[On]),SUM('Data'[Total])),"0.00%")

Total is a calculated column not a measure.

Should I write ratio formula differently? Or what should I do?

Thanks in advance!

[manikumar34]

@Anonymous ,

When you use FORMAT function and format to percenatge it converts to String Value. 

Because of whcih the value will not appear on visuals Except on Table, Crad and Matrix. 

If you want to change it to Percenatge use Column tools or Measure tools to change the data type to percenatge. 

Regards, 

Manikumar

Appreciate your Kudos, Accept as Solution if this is helpful.

[MFelix · Accepted solution]

Hi @Anonymous ,

When you use format you are transforming you calculations into text values in this case since you are using a division simply format the value in percentage using the measure bar options no need to use the format syntax then you can use it on your charts: