Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
hbgv123
Frequent Visitor

create temporary table based on selections and create calculated columns

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

ProductCategoryRegionProfitSales
AAFashionUSA31173
AAFashionCanada42223
AAFashionChina32294
AAFashionAustralia50226
AAFashionIndia33195
BBFashionUSA13100
BBFashionCanada5233
BBFashionChina2500
BBFashionAustralia4177
BBFashionIndia28100
CCFashionUSA24118
CCFashionCanada14152
CCFashionChina20220
CCFashionAustralia10211
CCFashionIndia29168
DDFashionUSA11207
DDFashionCanada26124
DDFashionChina30183
DDFashionAustralia25222
DDFashionIndia20267

 

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

 expected_Output.jpg

Thanks

1 ACCEPTED SOLUTION
v-bmanikante
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-bmanikante
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.