Calculate Average excluding excluded values

[cbruhn42]

I have a report that shows values on a line chart and then a card that displays the average of the values.

Is there a way to look for excluded values on my line chart and calculate the average in the card?

[Ritaf1983]

Hi @cbruhn42 

Yes, there are options to achieve this! You have two main approaches:

1. Use a Visualization-Level Filter: You can apply a filter directly on the line chart to exclude specific values. This will ensure that only the filtered values are displayed on the chart, while the card can calculate the average without applying the same filter.

2. Create Two Separate Measures: One measure for the line chart and another for the card. For the line chart measure, you can use the CALCULATE function with a filter to exclude the desired values.

Here’s an example formula for the line chart measure:

DAX
Copy code
LineChartMeasure =
CALCULATE(
[YourOriginalMeasure],
FILTER('YourTable', 'YourTable'[YourColumn] <> "ExcludedValue")
)
Replace [YourOriginalMeasure] with the measure you’re using for values, 'YourTable' with your table name, and specify the condition in the FILTER function to exclude the values you don’t want on the line chart.

For more specific suggestion 

Please provide a workable sample data and your expected result from that. It is hard to figure out what you want to achieve from the description alone.  

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

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

[cbruhn42]

So, I want to exclude the values that I right click on and select exclude.  So they show up in the Filter pane on the right.  How do I reference those values for my measure on the card.

I want the card to calculate the average by excluding those excluded values from the line chart visual.

[Irwan]

hello @cbruhn42 

i am not sure how your data to be excluded looks like, but to exclude a group of certain value in visual, you can use visual filter.

Otherwise, you might want to change the DAX in order to filter those values so it will not appear in your visual. something like CALCULATE('expression',FILTER('Table','expression)).

Thank you.