Calculated measure for visual tables with manually excluded lines?

[japande]

Hi,

I have built a visual table in Power BI that contains most data from one data table. I have added a calculated measure to the table to show the average for a specific column and it takes the splicers on the same page into account (which is great). However, I also would like it to take manually excluded lines (rightclick on the visual and "excklude" in the visual table into account, which I can't figure out how to do. 

The idea is that my clients can exclude (qualitatively described) issues from a list of issues with their product that they have already solved or plan on solving and the page shows them some calculated projections on how excluding (addressing) these issues might impact their KPIs.

I would be very grateful for any help with this issue!

Thanks alot in advance and best wishes,

Jan

[v-yulgu-msft]

Hi @japande,

Based on my test, manually excluding records in a visual won't affect the results calculated by measures. Also, exclude some records in a visual won't cross filter another related visual.

I'm afraid your requirement cannot be achieved now.

Regards,

Yuliana Gu

[japande]

Hi Yuliana,

Thank you for your quick answer - I'll need to find a different way to achieve this then...

Best wishes,

Jan