Forum Discussion
alee5210
Helper II
Helper IIMatrix Rollup When Using Text
Hi, I am having some issues with the matrix visual when I want text to roll up. Right now I have some data that looks like the below. It is simple with the main city, the store, how the store is perf...
I have found a solution using the measure below:
Test Measure =if(count('Test Data'[Comment])=1, -- Count the number of comments and if it is equal to 1selectedvalue('Test Data'[Comment]), --Then use the comment that is 'provided'calculate(selectedvalue('Test Data'[Comment]), 'Test Data'[Comment Number] = max('Test Data'[Comment Number]))) -- If there is more than one comment then select the comment where the comment number is equal to max(comment number)This seems to give me the result I am looking for in this case.It does not solve the first case though when you expand it, once expanded the top level is blank which is something I will live with.
alee5210Helper II
Helper III have found a solution using the measure below:
Test Measure =
if(
count('Test Data'[Comment])=1, -- Count the number of comments and if it is equal to 1
selectedvalue('Test Data'[Comment]), --Then use the comment that is 'provided'
calculate(selectedvalue('Test Data'[Comment]), 'Test Data'[Comment Number] = max('Test Data'[Comment Number]))) -- If there is more than one comment then select the comment where the comment number is equal to max(comment number)
This seems to give me the result I am looking for in this case.
It does not solve the first case though when you expand it, once expanded the top level is blank which is something I will live with.
- lbendlin
Super User
That's where ISINSCOPE would have come into play.
