Help with a calculated column

[nmck86]

Hello! I was hoping I could ask for help on a query issue I have ran up against. 

I have the attached pbix file and a BU TYPE 2 column that I am trying to pull in the area from a different table. Long story short I am trying to get the 2 visuals below to have matching totals across each month. One is for BU Type and the other even though it is titled BU Type 2 it is really AREA. Essentially I need my bottom graph to match the top one except using the EA, FA, Other or blank options.

 correct visualincorrect

I would love to get my BU2 or my BU Type 2 fields to wor correctly and match from a total perspective with the top chart. Any help would be amazing. The pbix file is below.

 https://drive.google.com/file/d/1PvVODz4RZ6NyihKiVK32WkPUE_ysIiOo/view?usp=sharing

[v-juanli-msft]

Hi 

I'm afraid it is not possible to make your bottom graph to match the top one except using the EA, FA, Other or blank options.

Using lookupvalue funtion to get BU and BU TYPE 2 column, but they can't match each other, so when you use them to generate monthly values, the values can't be the same.

Best Regards

Maggie