DAX "New Measure" for AVERAGE of slicer value

[Kirk_1]

I'm new to Power BI and DAX.

I have this "New Measure" that works correctly for the total % of items worked in the table.

Goal = AVERAGE('Distribution'[% Items Worked])

I need to know how to change this to show % of items worked based on slicer filters. I tried using ALLSELECTED, but I must not be writing the command correctly. Please help.

[v-zhangti]

Hi, @Kirk_1 

Is this the result you expect?

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel.

Best Regards,

Community Support Team _Charlotte

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

[FreemanZ]

hi @Kirk_1 

be careful when averaging a percent, it might get the unexpected result.

have you tried:

Goal =

CALCULATE(

    AVERAGE('Distribution'[% Items Worked]),

   ALLSELECTED(Distribution)

)

in case of issue, could you post some sample data?