Average of a column in a slicer object

[Anonymous]

Hi all!

I wonder if is possible to put in a slicer average of a column. I have created a measure, but slicer object does not support a measure, only a column, so I cannot apply an average function.

Thanks.

[DimaMD]

@Anonymous  hi, Can you provide your expected result? And fictitious data, in a pbix or excel file

[Anonymous]

Thanks for your reply.

I have the following table:

And I want that slicer shows only the average for each category of fruit, that is, 3, 8 and 5.

Thanks a lot!

[DimaMD]

@Anonymous This is what you want

[Anonymous]

No, I want to put this values in a slicer object. That is, put the measure in a slicer object, but PBI does not support a measure, only a column, so I cannot apply an average function in a slicer object.

[DimaMD · Accepted solution]

@Anonymous Sorry, Sorry, I didn't understand at first that it was supposed to be a slicer, the first thing you need is to create a calculated table

table_ave = 
 SUMMARIZE('table','table'[Fruit name],"ave",AVERAGE('table'[Value]))

Let's create a relationship between the tables

file attached
Put the values ​​from the second table into the slicer