Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

issue with filter context formula

Hi all,   I am getting in the topic of filter context and I would like to create an easy formula in my report that filters based on values in another table.Somehow however it doesn't work and there...
Need Help
Show and Tell
David-Ganor's avatar
David-Ganor
Resolver II
4 years ago

Hi Anonymous 

 

First of all, you can create a realtionship between the tables - with direction from TableSelectedDepartment to 1,  So basically TableSelectedDepartment  acts like a dimension.

If that somhow not possible you can create the following measure:

SumHours=

Calaculate(Sum(Table1[hours])

,FILTER(Table1

,Table1[department]=TableSelectedDepartment[department]))

 

Hope it helps,

 

David Ganor

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks, I would indeed a measure as I made the connection in my database too difficult... 🙂 

     

    I understand the logic behind it, but when I try it in PowerBI, it seems that PowerBI only allows me to put a measure for TableSelectedDepartment[department]).

     

    SumHours=

    Calaculate(Sum(Table1[hours])

    ,FILTER(Table1

    ,Table1[department]=TableSelectedDepartment[department]))