I need label and calculated values

[Aruna_ln]

I have table

ColA,col2,col3

My reports i need labelname:calculated values

like below example

sum colA : 63

Total Calculated values:5 mean this values coming from ColA/Col2

this type of calculation  i have 10 rows

that 10 rows look like table

I need labelname then calulated values.

please anybody help me.

thanks

Aruna

[Greg_Deckler · Accepted solution]

Use an Enter Data query to enter your labels into a table in a single column like this:

Labels

Label1

Label2

Label3

Label4

The create a measure like this:

Measure = IF(HASONEFILTER(Labels[Labels]), SWITCH(MAX([Labels]),"Label1",SUM(Table1[HighBound]),"Label2",SUM(Table1[LowBound]),"Label3",SUM(Table1[OCR]),"Label4",SUM(Table1[HighBound])/SUM(Table1[LowBound]),"Label5",SUM(Table1[LowBound])/SUM(Table1[OCR])),"")

Put Labels column and Measure into a Table visualization.

[Aruna_ln]

Thanks sir