cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jpbi94
Resolver II
Resolver II

Two columns with extra row

Hi everyone,


I was wondering if it's possible to create a table with two columns with an extra row. I already have the following table:

Countries+RemainingCountries = UNION(VALUES('Population'[Country]), ROW("Countries", "Remaining Countries"))
I want to add the column Countries[Flag] to this formula, with also an extra row with "No flags for several countries". 
How can this be done? 
1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @Jpbi94 ,

 

I have to admit that I do not fully understand your requirement, but maybe the following article is helpful: Filtering the top products alongside the other products in Power BI - SQLBI

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey @Jpbi94 ,

 

I have to admit that I do not fully understand your requirement, but maybe the following article is helpful: Filtering the top products alongside the other products in Power BI - SQLBI

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Well, not exactly I was looking for, but this was even better! So, thank you!

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Solution Authors