cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
agulac Regular Visitor
Regular Visitor

Invoke multiple information from other columns

Hello Community!

 

I get a little bit of truble here:

 

Got 3 tables with this information as an example:

 

Table 1:

 

User    Team         Completed

 

User1  Team1         1

User2   Team1        0

User 3  Team1        3

 

Table 2:

 

User Team Completed

User 1  Team2   3

User2 Team2     4

User3 Team2    0

 

 

User Team Completed

User 1  Team3   5

User2 Team3     8

User3 Team3     3

 

 

So i need Help to show in a visualization the total completed of each team with a selector that allows me to select the team and a number card to show me all the completed SUM.

i think that maybe creating a "symbolic" table to relation with all the completed and team information would allow me to retribe the requiered information in a visualization but i can't do it.

 

Thank you! Smiley Happy 

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Invoke multiple information from other columns

Hey,

 

basically I'm wondering why you have multiple table.

 

From within PowerQuery I personally would appende the tables, so that I finally have just one.

image.png

 

Does this makes sense?

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Highlighted
Super User
Super User

Re: Invoke multiple information from other columns

Do UNION ( Go to Modelling-> New Table-> create a new DAX table using the UNION) of all 3 tables using DAX, so you will have all details in the DAX table. Then you can create a measure SUM(DAT_Table[Completed]) and pull this measure and team column in visuals.

 

Also you can use this measure in a Card as needed.

 

Thanks

Raj

Super User
Super User

Re: Invoke multiple information from other columns

Not sure whether you are doing this in Power Query or in DAX.

 

If you do in DAX - Yes, all modelling/calculations happen in Power BI inmemory.

 

If you get this error hile doing UNION in DAX, please share the snapshot of your formula. Something you are missing .

 

Thanks

Raj

6 REPLIES 6
Super User
Super User

Re: Invoke multiple information from other columns

Hey,

 

basically I'm wondering why you have multiple table.

 

From within PowerQuery I personally would appende the tables, so that I finally have just one.

image.png

 

Does this makes sense?

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
Highlighted
Super User
Super User

Re: Invoke multiple information from other columns

Do UNION ( Go to Modelling-> New Table-> create a new DAX table using the UNION) of all 3 tables using DAX, so you will have all details in the DAX table. Then you can create a measure SUM(DAT_Table[Completed]) and pull this measure and team column in visuals.

 

Also you can use this measure in a Card as needed.

 

Thanks

Raj

agulac Regular Visitor
Regular Visitor

Re: Invoke multiple information from other columns

Yes, it would be the best i guess, 

 

But when i append all the tables i get this error:

 

" Failed to save modifications to the server. Error returned: ' OLE DB or ODBC error:{DataFormat.Error} Too many fields defined..'. "

 

I'm getting my data set from an access db file. But i thinked that the Queries modeling in powerBI was storaged in the local file. Don't understand why this is traying to save the appened file in a database.

 

Do you know why this is happening? Smiley Frustrated

 

Thank you!

Super User
Super User

Re: Invoke multiple information from other columns

Not sure whether you are doing this in Power Query or in DAX.

 

If you do in DAX - Yes, all modelling/calculations happen in Power BI inmemory.

 

If you get this error hile doing UNION in DAX, please share the snapshot of your formula. Something you are missing .

 

Thanks

Raj

agulac Regular Visitor
Regular Visitor

Re: Invoke multiple information from other columns

HI Raj,

 

I was using the first option, PowerQuery.. 

 

Edit Querys -> Append Queries --> Append queries as a new.

 

don't know why i got this ODBC error Smiley Frustrated

 

Gonna try with DAX union, as you say to me before.

agulac Regular Visitor
Regular Visitor

Re: Invoke multiple information from other columns

Yes, 

 

Creating the Union formula to join all tabs and then the DAX SUM , was the  solution.

 

Thank you Raj