create temporary table based on selections and create calculated columns

[hbgv123]

Hello Powerbi Users,

I am trying to create temporary table based on my datamodel and then aggregate it at product level to find the right bucket. So far I am not successful in getting it down

DATA MODEL

Product	Category	Region	Profit	Sales
AA	Fashion	USA	31	173
AA	Fashion	Canada	42	223
AA	Fashion	China	32	294
AA	Fashion	Australia	50	226
AA	Fashion	India	33	195
BB	Fashion	USA	13	100
BB	Fashion	Canada	5	233
BB	Fashion	China	2	500
BB	Fashion	Australia	4	177
BB	Fashion	India	28	100
CC	Fashion	USA	24	118
CC	Fashion	Canada	14	152
CC	Fashion	China	20	220
CC	Fashion	Australia	10	211
CC	Fashion	India	29	168
DD	Fashion	USA	11	207
DD	Fashion	Canada	26	124
DD	Fashion	China	30	183
DD	Fashion	Australia	25	222
DD	Fashion	India	20	267

My output should be something like this. My chart in powerbi should be updated based on filters.

 

Thanks

[v-bmanikante · Accepted solution]

Hi @hbgv123,

Thank you for reaching out to Microsoft Fabric Community Forum.

@johnt75 Thank you for your quicke response.

I’ve attached the PBIX file with the data you provided. Please review it, and let me know if you have any questions or need further adjustments.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
B Manikanteswara Reddy

[johnt75]

You need the dynamic segmentation pattern - https://www.daxpatterns.com/dynamic-segmentation/