How to build visual based on summarized table which can interact with filter from base table

[Leonzzheng]

Let's say I have a table like below

Value   Group   Type

   2          A         old

   3          B         old

   5          A         new

   3          A         new

   4          B         new

   7          B         old

Then I want to create some visual based on summarized table from the above table, which is

Group     P50

  A           XXX

  B           YYY

the summarized table is grouped by group and let's say I want to calculate C50 value

Here is how I create my summary table:

Summary Table = SUMMARIZE(Table, Table[Group], "P50", PERCENTILE.INC(Table[Value], 0.5))

Now my problem is :

After I create a visual, I want to add "Type" from Table as a filter, which means when I check "old" or "new" or both, visual will change based on the filter (Summary table content also be filtered).

I cannot figure out how to make this work, but I am sure I have seen report with this capability before.

Please help!

Thanks!

[v-shex-msft]

Hi @Leonzzheng,

Power bi does not support creating a dynamic calculated column/table based on filter/slicer. They are stored on different data levels and the parent level not respond with child-level operations.

Notice: the data level of power bi.

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> virtual table of data view(measure, visual, filter, slicer)
Regards,

Xiaoxin Sheng

[amitchandak]

@Leonzzheng , It will not. Join with a common dimension again and try.

or create the measure to use filters/slicer values

[Leonzzheng]

Not quite understand your suggestion, if I create measure, I cannot group by "Group" for the percentile calculation.