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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.