Forum Discussion

nmck86's avatar
nmck86
Post Patron
8 years ago

Help with a calculated column

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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    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