Hi Guys, I need a measure where if my filter is selected i need my comments(Which are in Multiple line) else i need blank. Basically if i am using Max, i am getting the top comments, i am not gettingthe complect comments Attached is the screenshot. Thanks in advance for your support Regards,Nagesh

HI Anonymous , You can use following measure formula to achieve your requirement: Dynamic comment = IF ( COUNTROWS ( EXCEPT ( ALL ( T1[Region Name] ), ALLSELECTED ( T1[Region Name] ) ) ) > 0, CONCATENATEX ( VALUES ( T1[Region Comments] ), [Region Comments], "," ), CONCATENATEX ( VALUES ( T2[Region Comments] ), [Region Comments], "," ) ) Notice: 1. T1 is sheet1, T2 is sheet2. 2. Current power bi can't find out the difference between 'all selected' and 'unselected', so measure formula will recognize 'all selected' and 'unselected' as 'unselect'. Regards, Xiaoxin Sheng

Comments for filters | Microsoft Fabric Community

Forum Discussion

Related content

Dynamic Comments

Mobile layout deleted when disabling comments

PowerBI Comments - Pin a comment

Filter

Commenting out first line in DAX