table with 3 data segmentations

[Daniff]

Very good morning, thank you for your help.

In this project I want to have 3 segmentations of seller data, in which the first segmentation filters the first column, the second segmentation the second column, and the third segmentation the third column.

In other words, as seller A only sells product AA, the result will only have to appear the line for Product AA and three columns for each segmentation. Can you help?

thank you very much I leave the pbix file here.

https://we.tl/t-wR5tIxs4y0

[Anonymous]

Hi @Daniff ,

Sorry, still not very clear.

"In this project I want to have 3 segmentations of seller data, in which the first segmentation filters the first column, the second segmentation the second column, and the third segmentation the third column."

In the above sentence, what does segmentations mean? Do you mean three slicers?
And what does the first column, the second column, and the third column refer to?

How is product AA created? I downloaded your file and there is no Product column in the data.

What are Sell Out 1, Sell Out 2, and Sell Out 3? How are 1,0 and 3 calculated?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.