Consolidation

[Anonymous]

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

 

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!

[v-yulgu-msft]

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

[Anonymous]

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

[v-yulgu-msft]

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

[Anonymous · Accepted solution]

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