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 repo...
Need Help
  • 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'

     

     

     
     
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

try,

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

 

/Adam