cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skuruvatti
Helper I
Helper I

KPI - combine multiple Tables for KPI Matrix

Hi,

 

I am looking for an example of combining multiple tables for KPI matrices across the report. Please let me know how can I do that?

So, I have 3 tables with different application Names and has Status. Combine all 3 and display one table matrics with color coding.

skuruvatti_0-1632523697292.png

 

skuruvatti_1-1632523956777.png

Thanks in advance!

 

2 REPLIES 2
halfglassdarkly
Resolver I
Resolver I

If you just want to combine the three tables without summarizing - and so long as your columns appear in the same order in each table - you can create a calculated table in DAX using UNION:

 

CombinedTable = UNION(Table1,Table2,Table3)

 

Union works on column order, so it won't matter should the column names be different between tables, but woul matter if you had an inconsistant number of columns between tables, or different order.

 

Or if the column order is different, or you want to aggregate the data from each table, you can use SUMMARIZE to create a summary table from each table, and combine them with UNION.

 

Alternatively, handle this in Power Query using Append Queries.

 

Not sure how the logic for your RAG status color indicator works, given your status column is appears to be binary 0 or 1?

Actually, The column names are different from each table, and when I append the tables 2 columns are displayed rather than one. RAG is from the status

 

skuruvatti_0-1632779047425.png

 

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors