AS AVERAGED BY A CATEGORY

[Syndicate_Admin]

I need to create a card with the average value of the valor_kilo for business unit 2, but I don't like how to do it:

[Ashish_Mathur]

Hi,

Does this measure work?

AVG Measure = CALCULATE(AVERAGE(Sheet1[valor_kilo]),'Sheet1'[business unit]="2")

[v-chenwuz-msft · Accepted solution]

Hi Syndicate_Admin,

I have created some data to show the steps below, as the image you have provided is not clear.

There are two ways to achieve your requirements，measure or Filters. You can follow along with my steps.

Create a Measure

AVG Measure = CALCULATE(AVERAGE(Sheet1[valor_kilo]),FILTER(ALL(Sheet1),'Sheet1'[business unit]="2"))

And put it in card.

Or

Use the filters

Put the field valor_kilo in the card and Set the field's properties to the average value via the arrow as the following show.

Then drag the field business unit to the visual’s filters and select the checkbox 2.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , Screenshot and expected output is not clear

Averagex(Filter(Table, Table[Business Unit] =2), Table[valor_kilo])