Forum Discussion
How to make a Measure change when excluding data points
I am displaying batch cost information.
I have a measure to calculate the weighted average of the batches
# Weighted Average =
CALCULATE(DIVIDE([# Batch Total Cost],'# BatchMeasure Table'[# Total Yield])
)
If I shift and select the bars in the bar chart, it will change the weighted average.
Great!
However, if you exclude bars on the bar chart the Weighted Average DOES NOT change.
How to make it recalculate after the exluded bars in the same way you can just hold shift and select multiple bars
and get the proper weighted Average.
1 Reply
Depends on how you designed your measures.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
