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         ...
Need Help
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.