Forum Discussion

Leonzzheng's avatar
Leonzzheng
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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

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!

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

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

     

    or create the measure to use filters/slicer values

    • Leonzzheng's avatar
      Leonzzheng
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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