Forum Discussion
table with 3 data segmentations
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.
14 Replies
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.
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
I have checked your data, there is no product AA in that file. Can you provide the updated data file?
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.
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
i will try. many many thanks. i ll give you feeback. thanks
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.
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
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.
