Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter by related table

Hi guys,   I am building a report in Power BI and I want to show the hours of the teams in my company. For one visual I need the table Projects and TimeTransactions, for another I need just the Ti...
Need Help
  • Stachu's avatar
    Stachu
    6 years ago

    try this measure:

    Quantity_New =
CALCULATE (
    SUM ( 'TimeTransactions'[Quantity] ),
    TREATAS ( VALUES ( EmployementOrganization[Employee] ), Employees[Employee] )
)

    it shows the same values for Department 1 and 3, but I think that's because Employee A is in both departments 

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
6 years ago

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window). Also please specify which column from 'TimeTransactions' you want to show

Column1Column2
A1
B2.5

the solution will most likely be to use TREATAS to create a virtual relationship (https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/), but without specific example I cannot help more

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I made a power Bi file with the data.

I hope this link works, if it doesn't please let me know.

//Link removed

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    6 years ago

    try this measure:

    Quantity_New =
CALCULATE (
    SUM ( 'TimeTransactions'[Quantity] ),
    TREATAS ( VALUES ( EmployementOrganization[Employee] ), Employees[Employee] )
)

    it shows the same values for Department 1 and 3, but I think that's because Employee A is in both departments 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Works like a charm, Thanks!

      • Stachu's avatar
        Stachu
        Icon for Community Champion rankCommunity Champion
        6 years ago

        glad to help, have a good day 🙂