Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Not be grouped by

Hey! I got a bar chart, x-axis is list of brands, y-axis measure. Looks like this: (can't show x-acis due to company agreement). I need a measure that will be an average value of y-axis measur...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    Can you try a Line & Clustered chart, using the overall measure as seconday Y? I'll paste image for more clarity. My example is on profit margin %, but can be done for your overall SAT measure. I hope this helps..

    Measure for flat line:

    Profit Margin% ALL =
    var profit = CALCULATE(SUM(Data[Profit]),ALL(Data))
    var sales = CALCULATE(SUM(Data[Sales]),ALL(Data))
    return
    DIVIDE(profit,sales)
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hi:

Can you try a Line & Clustered chart, using the overall measure as seconday Y? I'll paste image for more clarity. My example is on profit margin %, but can be done for your overall SAT measure. I hope this helps..

Measure for flat line:

Profit Margin% ALL =
var profit = CALCULATE(SUM(Data[Profit]),ALL(Data))
var sales = CALCULATE(SUM(Data[Sales]),ALL(Data))
return
DIVIDE(profit,sales)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I won't work because let's say your sales in my case is a measure, not a column

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    Can you provide example data (and image of key tables in your data model)as it should be possible to create a measure showing the values you want as a straight line? 

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Table: Both;
      Columns: Brand, Person_ID, Question, Answer, answer_code, Type
      Measure: 

      % satisfaction  =
      var t1b = CALCULATE(distinctcount('Both'[person_id]), or(Both[answer_code] = "5", Both[answer_code] = "4"), Both[Type] = "Satisfaction")
      var total_cnt = calculate(distinctCOUNT(Both[person_id]), Both[Type] = "Satisfaction")
      return t1b/total_cnt

      So, it just counts the % of positive answers, and I show it as % per brand in a bar chart(x-axis - brand, y-axis - satisfaction measure. How to show average satisfaction by brand on the same bar chart as line?