Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

**HELP** Display only specific data

Hi Folks, 

 

it's been a while since my last question. Power BI Journey is going fairly well. 

But yet again I need some assistance from you clever folk. 🙂 

 

Here goes:

 

I'm creating a report which will allow leadership team to better see our expenses and time efforts. 

 

I'm getting an excel with a source data from another team. 

This source Data Contains EVERY time report and EVERY transaction happening at the Project Account Level

The source excel file contains Column "TEAM" 

This Column contains names of the Teams such as "App Development" / "Agile Coaches" / "SIQ" / "Training" / DevOps"

 

1. I'm interseted to ONLY use the data that belongs to the team "SIQ" and nothing else. This Power BI Report will focus only on this one team and no-one else. 

I understand that I could open the excel and remove all the rows for all the other teams and only leave rows containing SIQ in the source file. But I would like to know if Power BI can do this manipulation for me and how.

 

2. I have also created two measures, that sums up all the hours (Total Hours) and all the expenses (Total Expenses)  but yet again, these measures sum up the total hours and Total Expenses of ALL the teams.  I'm only interested in summing up Expenses and Hours for "SIQ" Team. 

 

My simple measures looks like so:

Total Hours = SUM(Hours_Data[Hours])
Total Expenses = SUM(Expense_Data[Reporting Currency])
 
I truly apprciate your time and help with this.
 
Best Regards,
Kris
  • Anonymous's avatar
    Anonymous
    6 years ago

    For Question 1:

    Open up the Data view > Transform Data dropdown > Transform data > Select the "Team" column dropdown and apply a filter to show only SIQ. 

     

    Then hit 'Close & Apply'

     

     

     
     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    For Question 1:

    Open up the Data view > Transform Data dropdown > Transform data > Select the "Team" column dropdown and apply a filter to show only SIQ. 

     

    Then hit 'Close & Apply'

     

     

     
     
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks sduffy,

       

      this is a case where there is no need to overthink and overcomplicate things.

      I didn't think about such a simple solution because I thought that I will need some DAX formula for me to see the results, but in fact it was simply filtering the query. 😄 

       

      BR,

      Kris

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    try,

    Total Expenses = Calculate(SUM(Expense_Data[Reporting Currency]);Expense_Data[TEAM] = "SIQ")

     

    /Adam