Segmentation within a table of total measures.

[Syndicate_Admin]

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!

[v-yingjl]

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.

[Syndicate_Admin · 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.