Column Header Grouping problems

Hi usernamen ,

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

Hi usernamen ,

On the file you shared I was able to replicate the table at first attempt no problem. But I believe I was able to identify your issue.

The question is about the order of the columns on you image you present header and then group:

If I do that I do not get the proper result:

If i change the order of the two columns then I get the result you want:

Before drill down

After drill down

I believe that is your problem, in this case the Header is the column you want to have at the lowest level while the group refers to the aggregation of those values:

Has you can see the Group column is repeated for each hearder value.