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

[HamidRezaSajjad]

pls have a look

https://drive.google.com/file/d/1BmisqD4IJfKW_-iBuHAE7SMaHkA5mdVh/view?usp=sharing

[Daniff]

Good afternoon, I managed it thanks to your help! thank you very much! In the three segmentations, how can I do so that the name selected in the first segmentation does not appear in the second segmentation?

[Daniff]

Can you please give an example of three data segmentations in the way you think is most correct? It's a good exercise!

[Daniff]

I already checked and that's it. Would it be possible to replicate it to 3 salespeople to understand what was done in this case in terms of formulas? By the way, when a seller does not sell the product from the seller selected first, it should appear as zero. thank you very much

[HamidRezaSajjad]

you can freely add any dimesnion in Row and you can replicate salesPerson as much as you need. but have in mind that it would be better you make distinguish between Lookup Tables (SalesPersons) and FactTables(Performance). in addition, you can also shape your data in more flexible manner so that use only one Custom Table for slicing Persons.

[Daniff]

i will try. many many thanks. i ll give you feeback. thanks

[HamidRezaSajjad]

in this bi, as you can see, there are 2 measures1 and measure2 which related to Name1 and Name2 and you can change them independently.

[HamidRezaSajjad]

if i understood correctly, you need a 3-columnear table in which each column represents the sellout of any seller you specify through a slicer. correct? if so,  you can handel it with DAX and PowerQuery.

[Daniff]

correct, and in the first segmentation I can change the seller just like in the second and third segmentation. Can you please develop it in power bi to see how you did it? thanks

[nirali_arora]

I have checked your data, there is no product AA in that file. Can you provide the updated data file?

[Daniff · Accepted solution]

there https://we.tl/t-wR5tIxs4y0  

[HamidRezaSajjad]

 hello.can you pls share sample data? my primary suggestion, if i grasped it correctly,  is to first shape data via powerQuery and then calculate measure based on your requirements.

[Daniff]

correct, and in the first segmentation I can change the seller just like in the second and third segmentation. Can you please develop it in power bi to see how you did it? thanks

[Daniff]

there https://we.tl/t-wR5tIxs4y0 

thank you for your reply. i try in power bi.