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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

Segmentation within a table of total measures.

Hello!

I ask for the help of the community with a problem that has arisen:

I have a table that brings together the measurements of another such that like this:

Auxiliar Table = {
([Revenue]; [Expenditure])
}

where:

Revenue = sum(GeneralTable[Revenue])

Expenses = sum(GeneralTable[Expenses])

and GeneralTable contains as columns Income, Expenses and 3 columns that form a hierarchy of Country, City and Store.

If I create a visualization from the GeneralTable and a segmentation with the hierarchy, it works without problem, but if I put the measurements of theAuxiliar Table do not respond to that segmentation.

Is there a way to make the measures in theAuxiliarTable responsive to the segmentation of The GeneralTable? I think that we will have to complement the measures with some function that associates the two tables, but I do not know which one.

I appreciate the help in advance!

Thanks a lot!

1 ACCEPTED SOLUTION

Thank you very much for your reply.

I am now aware that the filter context is missing, my mistake. I thought it would work the same as "=DYNAMICDATAIMPORT()" in Excel and I could segment around.

Thanks to your feedback, I obtained the solution using an IF(HASONEVALUE()) + VALUES to bring the data from one table to the other respecting the filter context of the first.

In any case, thanks for the help.

View solution in original post

2 REPLIES 2
v-yingjl
Community Support
Community Support

Hi @Syndicate_Admin ,

Since there is no context in the tables, so the table values would not work in the visualization.

Need to add related columns to the table. By the way, under this way, why not use the measures directly in the visual instead of creating a 'table'?

 

Suppose that you want to create a table to arrange these measures, you can refer these articles to create a 'Measure table' in power bi desktop:

  1. Measure Tables in Power BI 
  2. How To Use A Measure Table In Power BI 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much for your reply.

I am now aware that the filter context is missing, my mistake. I thought it would work the same as "=DYNAMICDATAIMPORT()" in Excel and I could segment around.

Thanks to your feedback, I obtained the solution using an IF(HASONEVALUE()) + VALUES to bring the data from one table to the other respecting the filter context of the first.

In any case, thanks for the help.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors