Forum Discussion

LiorG's avatar
LiorG
Frequent Visitor
9 years ago

Cost Overview

Hello all,    How do I create something like the picture attached, assuming I use SQL data base and have 4 columns: 1- Total Fee, 2- Third party, 3- Travel Expenses, 4- Other any ideas?   ...
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

LiorG

 

Ok, Look the image and you'll see that i use a Stacked Bar Chart and in values section Use NetFee, ThirdParty and the other columns.

 

You can change the data label going to format and select what do you want to display.

LiorG's avatar
LiorG
Frequent Visitor
9 years ago

Vvelarde

 

ahh, I taught to use the Total fee as a limit, so I won't need the net fee.

thats because each of the variables located in different files, and when creating calculated column I can only use the data in the same file.
do you know how it's possible to creat maybe new file the variables I need from different files in order to calculate the net fee?

Thanks,
Lior

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    LiorG

     

    If the tables are related you can use a Measure to this calculation.

     

    NetFee = Calculate(sum('TABLEA'[TotalFee])-sum('TABLEX'[ThirdParty])-sum('TABLEZ'[TravelExpenses])-sum('TABLEW'[OtherExpenses]))

     

     

    • LiorG's avatar
      LiorG
      Frequent Visitor
      9 years ago

      Hi Vvelarde

      seems like unfortunately not all the table are related, I tried the use the line you wrote and power BI does not let me.
      I appreciate your help , thank you very much.

      Lior

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        LiorG

         

        Post  data model and sample Data to try to solve it