Forum Discussion

Aruna_ln's avatar
Aruna_ln
Helper III
9 years ago
Solved

I need label and calculated values

 

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    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.

     

     

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    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.