Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Consolidation

How can the Flex and COBRA columns be consolidated given this data?:

1.PNG 

Rather than trying to calculate things for each and every combination of names, I just need a single column that will give me all of each person's data regardless of the type of manager they are. Thanks!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @v-yulgu-msft , the answer to the solution can be found here:

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Situation/m-p/420900#M193486

 

The user posted 2 options and the option that I'm implementing on my report is #1

View solution in original post

4 REPLIES 4
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

Based on current description, it is not clear about your requirement. Is above sample table the original dataset? Or the values shown above has been aggregated?

 

What is your desired result? How to calculate for each and every combination of names? Which column represents type of manager?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft I've since then figured out the answer to my own problem. Thank you for reaching out!

Hi @Anonymous,

 

Glad to hear that you have resolved it by yourself. Would you please kindly share your solution so that it can benefit more users?

 

Thanks,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft , the answer to the solution can be found here:

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Situation/m-p/420900#M193486

 

The user posted 2 options and the option that I'm implementing on my report is #1

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.