Return Distinct values Where condition is met

[Gonqq]

Hi,
I have a table named "Áreas" where i specify what Cost Centers are inactive. Those Cost Centers shouldn't have values on Accounting. I have another table with a Balance Sheet from Accounting. The objective is to list all Cost Centers that are inactive but still have values atributed to them and present them in a card visual.
Until now i could only come to the sum of the values where Cost Center = inactive and im having trouble isolating the actual Cost Centers and present them on a visual.

Formula that I currently have

Thank you in advance,

cheers

[v-xiaoyan-msft]

Hi @Gonqq ,

I'm not quite sure if I understand your needs accurately.

 Samples(without sensitive information)and expected output would help tremendously.

Please see this post regarding: How to get your question answered quickly

Hope it helps,

Community Support Team _ Caitlyn Yan

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

[lbendlin]

Do you have an idea of how these cost centers should be shown?  As a table?  As a single string?