Hi

Question

I want when user to click on the matrix cell then filter all the records. show all the records of this cell to another table

How can I pass a measure dynamically in the following code?

table = filter(tablename, condition=[measure])

I want the measure to be automatically updated when a user clicks on a matrix cell. How can I achieve this?
Like Show in the bellw screen shot

amitchandak · Accepted Answer

muhammadraun10 , I doubt that. But if you use a calculation group, measure will become a dimension value too, then you can get what you are looking for&nbsp; 
&nbsp;
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Forum Discussion

Hi

2 Replies